Indexing

Question

Post reply

Indexing

vino.kumar587

SSC Rookie

Points: 26
More actions
February 22, 2010 at 12:29 am

#215989

Can i know how many nvarchar(max) column can add in one index?. Its very urgent situation.
please replay to this mail id : vino.kumar587@gmail.com
Thanks
Vinoth Kumar.T
Contact No : +91-9488667612

Viewing 7 posts - 1 through 6 (of 6 total)

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

wschampheleer SSCertifiable Points: 5504 More actions · Answer 1

Check BOL.

Regards,

Willem
http://wschampheleer.wordpress.com[/url]

Andrew Gothard-467944 Hall of Fame Points: 3928 More actions · Answer 2

You can't have an mvarchar(max) as a key column (a searchable column) in an index. Only as an included column

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

vino.kumar587 (2/22/2010)
Can i know how many nvarchar(max) column can add in one index?. Its very urgent situation.

Can I ask why you are wondering, and why it is so urgent? It seems like an odd question...

Paul

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

Andrew Gothard-467944 Hall of Fame Points: 3928 More actions · Answer 4

Paul White (2/22/2010)
vino.kumar587 (2/22/2010)
Can i know how many nvarchar(max) column can add in one index?. Its very urgent situation.
Can I ask why you are wondering, and why it is so urgent? It seems like an odd question...
Paul

anyone prepared to bet against something along the lines of "The developers ... every text field is nvarchar(max) ... performance terrible ... I've been asked to tune ... "

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

Andrew Gothard-467944 (2/22/2010)
anyone prepared to bet against something along the lines of "The developers ... every text field is nvarchar(max) ... performance terrible ... I've been asked to tune ... "

Not me :laugh:

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

GSquared SSC Guru Points: 260824 More actions · Answer 6

You can include any number of them in an index. You can't have them as the key columns for the index. It's really as simple as that.

Often, you're better off using a full text index on that kind of column, instead of a regular index.

What problem are you trying to solve by indexing these?

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon