help: oracle table index issue

From: Fuqun Zhou <fuqun.zhou_at_ccrs.nrcan.gc.ca>
Date: Wed, 15 Jul 1998 15:32:07 -0400
Message-ID: <35AD03B7.72F892DE@ccrs.nrcan.gc.ca>

Hi,

We have a table which holds a huge number of records. The table is sorted in ascending order by date. But if I want to select some records of the most recent date, it will take a very, very time to get records back.

Question:
How to build an index on this table and how to use the index to efficienly rereive the most recent records with the most recent date?

Any help will be appreciated.

Fuqun Received on Wed Jul 15 1998 - 14:32:07 CDT