According to my friend who is a very experienced Oracle DBA there is a way to change/control execution plan in Oracle. He even told me how he does but of course I forgot :). He told me that the same SQL Select could take from 5 seconds to several hours depending on the execution plan.
>What do you mean here? How would you change execution plan?
>
>>I was talking to a friend today who is a DBA for Oracle database. He was telling me how he can speed up execution of SQL Select by changing execution plan. These things are so over my head :) But I am learning, little by little. Thank you.
>>
>>>When you use a derived table in a query it doesn't mean that SQL Server Query processor will literally run such subquery. The query optimizer may rearrange the query to make it more efficient. Sometimes you may get the same execution plan as your previopus query w/o derived table.
>>>
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
