Re: A simple SELECT ?

Create an index on customer_id and date, called eg. del_cusdat.

select /*+ index_desc(del_cusdat) */ date, quantity  from deliveries d
 where d.customer_id = ...
 and rownum <= 10;

ACT_at_BLUEGATE heeft geschreven in bericht <7i3sr8$js8$1_at_xenon.inbe.net>...
>It seems simple...
>
>I've a deliveries table with three columns: date, customer id, and
quantity.
>
>How can i retrieve in a query the last (in time) 10 deliveries for a
>specified customer ?
>
>Achille Carette, Bluegate
>act_at_bluegate.be
>
>
Received on Fri May 21 1999 - 13:57:39 CDT