Hi,
Is it advisable to create a Non Clustered Index in "ALLow NULL" column?
Thanks,
Rahul JhaDepends on the requirement.
To turn it around - should a nullable column prohibit an index? No :)|||for that matter it's also possible to create a clustered index on a nullable column.|||but problems will arise if you make your index unique on a nullable column.|||but problems will arise if you make your index unique on a nullable column.
Not really, you will only be allowed on null "value"
which makes no sense
http://weblogs.sqlteam.com/brettk/archive/2005/04/20/4592.aspx
No comments:
Post a Comment