Appendix C: Database Improvement Steps

Overall the database improvements will be divided into two categories:

 

1.      The DBA procedures to improve the Server and the database running abilities

2.     The upgrade script to add missing indexes, disable unused indexes, bring new changes to the functions and procedures, change the way the sequence objects work, new stored procedures for the reports, new tables to support the new sequence management. (Script A & B are the upgrade scripts)

Related Topics

Appendices
The DBA steps (somewhat manual)


iNovah Administration and Management Portal Guide Copyright © 2010 by System Innovators, a division of N. Harris Computers, Inc. The System Innovators logo and name is a registered trademark of System Innovators. iNovah and the iNovah logo are both trademarks of System Innovators. Windows is a registered trademark of Microsoft Corporation. This document may not be reproduced or transmitted in any form or by any means, electronic or mechanical, for any purpose other than the customer’s own use without written permission from System Innovators. System Innovators 10550 Deerwood Park Blvd., Suite 700 Jacksonville, Florida 32256