Evaluate Weigh the pros and cons of technologies, products and projects you are considering.

Working with a query optimizer

On what circumstances will the query not use the index on a column? For example, I have an index on column A and if I use operator <> or IN(), will it use the index or full table scan?
In general, the query optimizer avoids using an index for scanning when the selection criteria returns a large number of rows (e.g., greater than 10 or 20% of the rows are selected). Read the Indexing Strategy white paper online for more details here.


Check out this Search400.com Featured Topic: Expert advice on DB2

Search400.com's targeted search engine: Get relevant information on DB2/400.

The Best Web Links: Tips, tutorials and more.

This was last published in October 2004

Dig Deeper on DB2 UDB (universal databases)

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.



  • How do I size a UPS unit?

    Your data center UPS sizing needs are dependent on a variety of factors. Develop configurations and determine the estimated UPS ...

  • How to enhance FTP server security

    If you still use FTP servers in your organization, use IP address whitelists, login restrictions and data encryption -- and just ...

  • 3 ways to approach cloud bursting

    With different cloud bursting techniques and tools from Amazon, Zerto, VMware and Oracle, admins can bolster cloud connections ...