Re: Getting detailed informations of a sql-statement

Hi Astrid,

well... If you ain't got any tools to use, the "Explain Plan" might be useful.

hth
Guido

agrudzinski_at_cs-controlling.de schrieb:

> Hi,
> I do need to check, if my program's access to
> oracle-tables should be optimized. For this I would
> like to know, if the sql-statement is using an
> index or anything optimized routines (e.g.: if I do
> select the data with a combined key, one field
> exists as index, others not; does the select use
> this index or does it prefers a full table scan?).
>
> Which possibilities do I have to analyze
> bad performance?
>
> Thanks in advance,
>
> Astrid Grudzinski
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Thu Oct 15 1998 - 08:02:28 CDT