This document applies only to the following language version(s): English
Abstract
This list features the most requested documents as well as those identified as valuable in helping answer your questions related to IBM Maximo Asset Management. The list will be updated periodically to reflect new trends and issues.
SQL Server 7 and 2000 Performance: Index Tuning (1261979) Rebuilding indexes or updating statistics can improve performance on Microsoft SQL Server. If clustered indexes are missing or statistics are out of date, you may experience performance and locking problems. Commands like update statistics and dbcc dbreindex should be run periodically and should normally be run when users are not accessing the tables being updated. This document applies to SQL Server database environments only and can be used for SQL Server 2005 as well.
Use CURSOR_SHARING=FORCE or SIMILAR for best performance (1262959) Maximo does not use bind variables for user specified where clauses, which are used in most queries. You should set the database parameter CURSOR_SHARING to FORCE or SIMILAR to improve performance.
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.
Rate this page
Please take a moment to complete this form to help us better serve you.