Friday, March 9, 2012

Non Clustered Index

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