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: doubt on order of table scan

Re: doubt on order of table scan

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Sat, 15 Oct 2005 10:28:12 +0200
Message-ID: <4350bd90$0$7366$636a55ce@news.free.fr> 






"Sreelal" <sreelalpp_at_gmail.com> a écrit dans le message de news: 1129363914.232261.93900_at_f14g2000cwb.googlegroups.com...


|

| hi all,

|

| 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

|




In any order it wants.


It depends on Oracle version, structure (partition, index...), query, parallelism...



Btw, there is neither top nor bottom of a table.



Why do you want to know that?



Regards


Michel Cadot
Received on Sat Oct 15 2005 - 03:28:12 CDT












Original text of this message













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