Getting detailed informations of a sql-statement

From: <agrudzinski_at_cs-controlling.de>
Date: Thu, 15 Oct 1998 10:47:42 GMT
Message-ID: <704jse$es7$1@nnrp1.dejanews.com>

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 - 05:47:42 CDT