| |
GeekInterview.com > Tech FAQs > PL/SQL
| Print | |
Question: How do you Optimize query
Answer: How can i choose which query is best?
i.e On which factors i can choose the best query? |
| July 07, 2008 06:01:23 |
#1 |
| madanuprashanth |
Member Since: July 2008 Total Comments: 1 |
RE: How do you Optimize query
|
By forcing the SQL engine to use indexes.
If query is too much nested then break it into two or three queries using temp tables and then write one query by joining these temp table to perform the task. |
| |
Back To Question | |
