Problem solve Get help with specific problems with your technologies, process and projects.

Tom Kyte's frequently asked questions and myths about indexes

Tom Kyte, author of the new book "Expert Oracle Database Architecture: 9i and 10g Programming Techniques and Solutions," fields many questions about Oracle databases and tools. He finds that the topic of indexes attracts the most questions of all. Here, he provides answers to some of the most frequently asked questions. Some of the answers may seem like common sense, while other answers might surprise you. Suffice it to say, there are lots of myths and misunderstandings surrounding Oracle indexes.

Tom Kyte, author of the new book Expert Oracle Database Architecture: 9i and 10g Programming Techniques and Solutions, fields many questions about Oracle databases and tools through his "Ask Tom" column in Oracle Magazine and at asktom.oracle.com. He finds that the topic of indexes attracts the most questions of all. Here, he provides answers to some of the most frequently asked questions. Some of the answers may seem like common sense, while other answers might surprise you. Suffice it to say, there are lots of myths and misunderstandings surrounding indexes -- here are a few:

Tom Kyte is Vice President of the Core Technologies Group at Oracle and has been using Oracle since 1988.


This was last published in October 2005

Dig Deeper on Oracle DBA jobs, training and certification

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close