Oracle FAQ

Your Portal to the Oracle Knowledge Grid

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US

Home -> Community -> Usenet -> c.d.o.misc -> Re: select and rownum and order by

Re: select and rownum and order by

From: Tim Loss <tloss_at_gate.net>
Date: 1998/01/15
Message-ID: <34BE979D.1D608AB8@gate.net>#1/1

You need to index on date. if you sort Oracle always sorts the entire table then returns the selection.
Tim Loss Received on Thu Jan 15 1998 - 00:00:00 CST

This message: [ Message body ]
Next message: TimeVest Inc.: "sql*loader puts in in, how do I put it out"
Previous message: Laurent LETANG: "select and rownum and order by"
In reply to: Laurent LETANG: "select and rownum and order by"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US