RE: Performance issue

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Mon, 02 Apr 2001 14:20:08 -0700
Message-ID: <F001.002DEEAB.20010402141023@fatcity.com>

> -----Original Message-----
> From: Pampati, Kiran [mailto:kpampati_at_cybersource.com]
>
> I have a table with 1 million records, If I search for one
> value of a column
> it comes very fast and if I do the same query for a
> different value on the
> same column it takes more time. I did not understand why it
> behaves like
> that. Any ideas..

Have you looked at the "explain plan" for both queries? In SQL*Plus, type in
set autotrace traceonly explain
and then run the query.

You will need to have the PLAN_TABLE created. The script to create that table can be found in $ORACLE_HOME/rdbms/admin/utlxplan.sql Received on Mon Apr 02 2001 - 16:20:08 CDT