thank you , it was very nice for tunning or in where clauses. i am new to oracle is there similar thing like set statistics io , time on and execution plan to analize in oracle ?
Yes, Oracle does have something similar called autotrace. You enable in SQL Plus with "SET AUTOTRACE ON". The key metric I look at is named consistent gets. You can associate consistent gets with Logical Reads in SQL Server. Autotrace will also provide query plan information.
Thank you Bro.
You're welcome!
thank you , it was very nice for tunning or in where clauses.
i am new to oracle is there similar thing like
set statistics io , time on
and execution plan to analize in oracle ?
Yes, Oracle does have something similar called autotrace. You enable in SQL Plus with "SET AUTOTRACE ON". The key metric I look at is named consistent gets. You can associate consistent gets with Logical Reads in SQL Server. Autotrace will also provide query plan information.