View Single Post

   
  #1 (permalink)  
Old 02-26-2008, 10:58 AM
Kris Koschik
 
Posts: n/a
Default indexes on null columns

What are the issues regarding creating a index on a nullable column?

For example there are 3 nullable columns. I want to add one index on
each of the 3 nullable columns:

Table1 : 100,000 rows

id bigint not null primary key
empid1 bigint nullable null 9/10 of the time
empid2 bigint nullable null 1/3 of the time
empid3 bigint nullable null 1/3 of the time

thanks
Reply With Quote