In order for indexing to be used effectively, storage engines need to provide the optimizer with information about the table and its indexes. This information is used to choose whether to use an index, and if so, which index to use.
Copyright © 1997, 2014, Oracle and/or its affiliates. All rights reserved. Legal Notices