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 23:29:11 +0200
Message-ID: <dirsif$ith$1@apollon.grec.isp.9tel.net>


"IANAL_VISTA" <IANAL_Vista_at_hotmail.com> wrote in message
> What happens if the index is on a NULLable column?

In Oracle NULL values are at end of result set

> So the most correct answer is "From the inside outwards!".

What does that mean? Received on Sat Oct 15 2005 - 16:29:11 CDT

Original text of this message

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