Re: how oracle treats rows..? help

On Sat, 15 Oct 2005 01:19:32 -0700, laloo wrote:

> can any body tell me,
> in which order oracle scans the rows in a table in normal select
> quries?
> ie, from top to bottom or bottom to top?
>
> regs,
> lal

It depends on the kind of bottom that the table has. If it's shapely and firm, then scanning definitely starts from there. If, on the other hand, you're listening to the Queen with the late Freddy Mercury....

-- 
http://www.mgogala.com