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: News <news_connection_at_yahoo.fr>
Date: Sat, 15 Oct 2005 20:47:04 +0200
Message-ID: <dirj4h$oj1$1@aphrodite.grec.isp.9tel.net> 





I don't know what matters but if I were who implement it I would sacn in the 
order of the indexed column if an index is used or in the order of page 
chains if it's scan without an index.





"Sreelal" <sreelalpp_at_gmail.com> wrote in message 
news:1129382729.191010.139910_at_o13g2000cwo.googlegroups.com...


> it was an interview question to my friend for a DBA position.

> thanx

> 

Received on Sat Oct 15 2005 - 13:47:04 CDT












Original text of this message













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