|
View previous topic :: View next topic
|
| Author |
Message |
mailsaurabh.tripathi
New User
Joined: 22 May 2008
Posts: 56
Location: hyderabad
|
|
|
|
| can anyone tell me how to run EXPLAIN. I'v created my PLAN_TABLE, but unable to load it using explain. |
|
| Back to top |
|
 |
Prasanthhere
Active User
Joined: 03 Aug 2005
Posts: 306
|
|
|
|
EXPLAIN Planname SET QUERYNO = 1
FOR Query
For selecting the results try this
Select * from plananame where query NO=1 |
|
| Back to top |
|
|
acevedo
Active User
Joined: 11 May 2005
Posts: 344
Location: Spain
|
|
|
|
| or in bind package set EXPLAIN(YES) |
|
| Back to top |
|
|
|
|
