Prakash,
- If your primary key is concatenated, check that you indeed have the
most significant column in first position, then the second less
significant etc. If there the first column can only take one or two
values, it could explain slowness. But this may entail reviewing
indexing on the table as a whole.
- If nothing wrong here, try an ALTER INDEX ... REBUILD NOLOGGING |
UNRECOVERABLE
--
Regards,
Stephane Faroult
email: sfaroult_at_oriolecorp.com
Oriole Corporation
Voice: +44 (0) 7050-696-269
Fax: +44 (0) 7050-696-449
Performance Tools & Free Scripts
------------------------------------------------------------------
http://www.oriolecorp.com, designed by Oracle DBAs for Oracle DBAs
------------------------------------------------------------------
>
> Hi All,
>
> I have some queries which take too long to execute,
> perform too
> many disk reads and affects very small no of rows. I
> have analyzed
> the table,indexes and there are no chained rows for
> this table.
> Explain plan says that the cost of the queries are 3/2
> etc and I
> don't know if they could be optimized any more. Please
> could
> anyone tell what could be wrong?
>
> The output of the TKPROF is following:(sorry for the
> bad formatting)
Received on Fri Jul 07 2000 - 05:30:07 CDT
