Re: speedup the query ~~

From: Malpar <soportetecnico_at_infisa-ca.com>
Date: 2000/04/26
Message-ID: <01bfaf58$755bda40$6301a8c0@pc-jmm>#1/1

Hello

You are making the query by PK which (excepting the access by rowid) is the most fast way because a Pk works like an index. Anyway you can use an utility of sqlplus ( or plsqldeveloper,or T.O.A.D.) called explain plan, with that you can see the type of access to the tables (full,index,rowid, etc) if you are accesing to the tables by rowid you can´t speed up the query.

if you want to speak about this themes write me to leunam40_at_hotmail.com.

Bye. Received on Wed Apr 26 2000 - 00:00:00 CDT