Re: how to tune up this query?

Hallo Susan,

> I have a 3 million records table. I want to retrieve the first
> 1000 records of the lowest number of priority.

You need no subquery:

> SELECT id, name, priority
> FROM table_name
> WHERE stage = 'start' and state = 1
> and rownum <= 1000;

Ciao Thomas Received on Wed Jan 29 2003 - 23:56:00 CST