Creating unique index
-
I have a column of type int(not a primary key).This column has unique values(other than NULL), but have some NULL also.Can i create unique index on that column?
-
You can have a single NULL value there. That's it. More than one, and it's not unique. You could try a filtered index instead.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
Only if you have one NULL.
-
Thank u all. I can use filtered index.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply