Re: Newbie Trying to Expedite Query
Thanks Mike,
The only column I really need for a PK is the auto-increment column.
Our retrieval query is always "Select <field list> From History Where run_date = '<some date>' And run_number = <some number> Order By <auto-increment-column>;"
Therefore, it seems like I need an index of run_date + run_number, right?
If I instead make the primary key run_date + run_number + auto-increment, and dispense with any other indexes, it seems like this would speed things up. I don't know enough to answer this, but wouldn't that also eliminate the need for "Order By <auto-increment-column>"?
Thanks...
Subject
Views
Written By
Posted
1296
May 30, 2013 05:11PM
755
June 03, 2013 01:24AM
677
June 03, 2013 10:54AM
689
June 04, 2013 02:09AM
Re: Newbie Trying to Expedite Query
598
June 04, 2013 09:25AM
614
June 07, 2013 01:30AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.