Re: Tunning Select and Where statements

From: Bernd Maierhofer <BerndM_at_dato.at>
Date: Tue, 5 Oct 1999 13:02:33 +0200
Message-ID: <7tcn0s$9j1$1@orudios.magnet.at>

Have a look at the EXPLAIN PLAN command. In addition, somewhere on the net there is a cute utility called ExplainSQL written by Keith Wood (110254.1265_at_compuserve.com). Which assitis you in tuning SQL statements.

HTH dato Denkwerkzeuge - Bernd Maierhofer
Corneliusgasse 4/5
A-1060 Wien , Austria
support_at_dato.at

Explain SQL (Oracle)
Ming schrieb in Nachricht <7sq3av$9ap_at_romeo.logica.co.uk>...
>Given the following statement :-
>
>SELECT name FROM people WHERE age = 21;
>
>Why would an index on 'age' in WHERE clause result in a slower query than
>having no index.
>Why would an index on both 'name' and 'age' result in a faster query.
>
>Thanks for any Help
>
>
>Ming.
>
>
Received on Tue Oct 05 1999 - 06:02:33 CDT