| Regarding Nulls in Indexes [message #308840] |
Tue, 25 March 2008 11:56  |
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.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
