Home » SQL & PL/SQL » SQL & PL/SQL » Regarding Nulls in Indexes
Regarding Nulls in Indexes [message #308840] Tue, 25 March 2008 11:56 Go to next message
oraspirit
Messages: 2
Registered: November 2007
Junior Member
I am confused over this topic regarding "Indexes and Nulls'

If I have three columns with A, B, and C containing rows as follows

A B C
_____________

RowID 1 1 Null 2

RowID 2 Null Null Null

will the first row be included in the Index containig A and B as keys.

________________________________________________________________

Also tell me a way to check it out
I want to know how to check the sql query is using the full table scan or the Index for getting result.
Re: Regarding Nulls in Indexes [message #308845 is a reply to message #308840] Tue, 25 March 2008 12:37 Go to previous messageGo to next message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ Yes
2/
set autotrace on
select A,b from t where a=2
There is no access to the table

Regards
Michel
Re: Regarding Nulls in Indexes [message #308861 is a reply to message #308845] Tue, 25 March 2008 13:27 Go to previous message
oraspirit
Messages: 2
Registered: November 2007
Junior Member
Thanx for your quick response. The confusion evaporated...

[Updated on: Tue, 25 March 2008 13:34]

Report message to a moderator

Previous Topic: What is the Main Difference b/w synonym and public synonym?
Next Topic: Where can I find any html parser that I can use in PL/SQL?
Goto Forum:
  


Current Time: Tue Dec 06 10:38:39 CST 2016

Total time taken to generate the page: 0.05681 seconds