|
|
| Re: how to generate execution plan? [message #49948 is a reply to message #49943] |
Wed, 20 February 2002 00:30  |
shivkumar
Messages: 8
Registered: February 2002
|
Junior Member |
|
|
say i use a query select * from emp;
The respective values are uploaded into the db buffer,
naturally
Parse
execute
fetch operation is done.
to analyse the system resource used for the execution of the abv stm ..we use explain plan
in the cmd prompt run the TKPROF utility,
give the output file as some s.trc,s.txt
now you get the info og
call,count,cpu,elapsed,disk,query,rows
type of optimizer=rule/cost
you can use hint all_rows/first_rows
say eg
select /*+first_rows*/ empno,ename from emp;
Try this
good luck
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
