> -----Original Message-----
> From: Pampati, Kiran [mailto:[EMAIL PROTECTED]]
>
> 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
