Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: How can know the index use by Oracle in a Qurey
The execution plan generated by 'explain plan' will tell you which indexes
Oracle intends to use.
For info on explain plan see your SQL Language Reference.
Some tools have a built-in explain plan utility.
Regards
Kurt
KurtL_at_corebit.dk
shaim wrote in message <01be536a$70e44740$2a64dac0_at_mid>...
>How can know the index use by Oracle in a Qurey
>
>A query in PL/SQL take a long time when I launch it !!!!
>I want to know the index use by Oracle.
>
>Thank MID.
Received on Mon Feb 08 1999 - 10:25:50 CST