On Mon, Aug 20, 2001 at 10:30:07PM -0700, Stephan Szabo wrote:
>
>
> I don;'t know if it's considered now, but that query (the
> original) doesn't necessarily require a sort step. With an index on
> (d,e) I think you could do the query using the index for both the
> constraint (d=2) and the ordering stopping when you have 10 rows.
I see. What I am asking is impossible then.
Thanks. I will have to go with two queries
approach