Primary key without cluster index

Question

Post reply

Primary key without cluster index

Viewing 5 posts - 16 through 19 (of 19 total)

You must be logged in to reply to this topic. Login to reply

SQLBalls SSCarpal Tunnel Points: 4621 More actions · Answer 1

.....well i'm down to a C..... 😀 I guess I can be President

Twitter: @SQLBalls
Blog: http://www.SQLBalls.com
Channel: https://www.youtube.com/@Tales-from-the-Field

Source-NH SSCarpal Tunnel Points: 4165 More actions · Answer 2

Paul White NZ (7/20/2010)Seeing as I am now in picky mode (you started it) I'm going to say that a filtered clustered index is possible (in a sense) just create it on a view that contains the filter condition 😀

I call shenanigans !!! That's a filtered view, not a filtered index 😛

Paul White SSC Guru Points: 150467 More actions · Answer 3

Rich-403221 (7/20/2010)
I call shenanigans !!! That's a filtered view, not a filtered index 😛

:laugh:

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

maran_tamil SSC Journeyman Points: 95 More actions · Answer 4

Yes, we can create Primary Kay without clustered index.

Eg:

CREATE TABLE MyTable (EmpNo INT PRIMARY KEY NONCLUSTERED NOT NULL, EmpName Varchar(30))

sunil.softmail Valued Member Points: 69 More actions · Answer 5

Primary key by default it will create one clustered index on table,unique creates up to 249 non clustered indexes.