Title: RE: Imedia query tuning
Hello,
Thanks
Lisa for your comment but.
I try
to always use an index hint to return the rows in the required
order. This avoids a sort
if
it's possible to use an index which can avoid both sort and table access - and
it often won't be poss
Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: RE: Imedia query tuning
Henrik, FYI
The ordered hint refers to the order in which the tables are accessed in the query. It has nothing to do with an index.
Lisa Rutland Koivu
Oracle
Title: RE: Imedia query tuning
Henrik, FYI
The ordered hint refers to the order in which the tables are accessed in the query. It has nothing to do with an index.
Lisa Rutland Koivu
Oracle Database Administrator
Certified Self-Important Database Deity
Slayer of Unix Administrators
Hello,
I'm not a guru : I just try to help you. :->
Hint for Query 2 :
Have you try to hint so you run on the editor_choice index. If it
works. Can you remove the Order command. Because the index is already
ordered.
Regards
Henrik E.
On Wed, 16 May 2001, Ranganath K wrote:
> Dear DBA Gurus
Hi Ranganath,
Do you realy need the subquery ? Try replacing the "... in (...)" condition
by "category.status=0". You already have a condition which states that
fk_category must equal pk_category_id.
If it's still slow: how many rows are there in each table ?
Remco
-Oorspronkelijk bericht-