Re: How can I view Oracle's SQL optimization

Look into the explain plan facility.

Oracle does not optimize queries for you. You supply a query and Oracle figures out the best way to retrieve the data ie use an index or table scan. Explain plan lets you know what route the database will take to get your data. Its up to you to tweak your queries to figure out which query is optimized.

On 7 Feb 1997 21:06:23 GMT, whitej8_at_mail.auburn.edu (Jason B White) wrote:

>oracle runs some algorithms to optimize queries how can I view the optimized queries?
>
>Please respond to whitej8_at_eng.auburn.edu
>
>Thanks
>
>--
>"A day job...in an office? My worst nightmare!" - The Tick
>
>%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
>% Jason White whitej8_at_eng.auburn.edu
>% Auburn University Auburn, Alabama
>%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
Received on Sun Feb 09 1997 - 00:00:00 CST