Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
gpayne
Starting Member
2 Posts |
 Posted - 2011-08-03 : 16:20:07
|
| Hi all. I am still learning some tricks of the trade with MS SQL and databases in general. However, I have a question. I have recently added a column of type NVARCHAR(15) to an existing table of mine. I was wondering if there would be any impact as to whether or not if I should place an index on this column as I will be doing searches against this new column. The column WILL NOT have unique values per record. Will this have a certain impact on the database? Will this speed up my search times? Any feedback would be greatly appreciated! Many thanks!!! GreggoryGPaynehttp://www.greggorypayne.com |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
gpayne
Starting Member
2 Posts |
Posted - 2011-08-04 : 08:24:11
|
| Thanks for the reply Tara. However, I would like to know, when would an index like this affect a query causing it to not be faster?GPaynehttp://www.greggorypayne.com |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-08-04 : 13:03:41
|
quote:
Originally posted by gpayne
Thanks for the reply Tara. However, I would like to know, when would an index like this affect a query causing it to not be faster?
When the query can't use the index, due to non-SARGable predicates or incorrect index column order.--Gail ShawSQL Server MVP |
|
|
|
|
|
|
Index - NVARCHAR(15)