How you will avoid your query from using indexes

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

How you will avoid your query from using indexes?

By changing the order of the columns that are used in the index, in the Where condition, or by concatenating the columns with some constant values.

(Continued on next question...)

Other Job Interview Questions

• Where is Jserv configuration files stored ?
• What is difference between ICM, Standard Managers and CRM in Concurrent Manager ?
• What is different between TRUNCATE and DELETE?
• What is forms server executable Name ?
• What are various options available with adpatch ?
• What is difference between AD_BUGS and AD_APPLID_PATCHES ?
• How to confirm if Report Server is Up and Running ?
• What is difference between ICM, Standard Managers and CRM in Concurrent Manager ?
• Why I need two Concurrent Processing Nodes or in what scenarios PCP is Used ?
• What are few profile options which you update after cloning ?
• More...