Forum Post: RE: Use-index prevent multiple brackets: documented?

  • Thread starter Thread starter Tim Kuehn
  • Start date Start date
Status
Not open for further replies.
T

Tim Kuehn

Guest
In your final scenario, USE-INDEX disables index bracketing, and the query isn't structured in a way the compiler can map anything in the WHERE phrase to the leading components of the specified index, so the compiler wrote the query as a TABLE-SCAN.

Continue reading...
 
Status
Not open for further replies.
Back
Top