O'Reilly logo

Oracle Database Administration for Microsoft SQL Server DBAs by Michelle Malcher

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Indexes

Indexes exist to help speed up queries. Having the proper columns indexed can reduce the logical I/Os for queries. However, creating an index to make one query run faster may not be a good solution. Begin by examining the SQL statements that are currently being run against the database. If the query can be adjusted, that would be a logical first step. This is the same for both SQL Server and Oracle platforms.

There are costs associated with data changes when the indexes are involved. The maintenance requirements should be considered. The performance gains of adding the index should be more than the cost of maintaining the index. Also, too many indexes can add to performance issues instead of resolving them. Indexes should be used selectively ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required