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 |
|
sachingovekar
Posting Yak Master
101 Posts |
 Posted - 2009-10-14 : 12:51:23
|
| Hi,My Table has million of rows.Table AcOLUMN 1 COLUMN 2There is a table in production database.Table Bcol 1 col 2I want to populate column 2 of table A by joining Table A WITH Table B on column1 = col1col1 of Table B has no index( its a production table).column 1 of table A has no index defined.Since there are millions of rows. If we implement a non clustered index on COLUMN 1 of table A, will there be any faster execution of query? |
|
|
scott_leseman
Starting Member
5 Posts |
Posted - 2009-10-15 : 07:41:36
|
| http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=microsoft.public.sqlserver.server&tid=a9d465fb-6a09-47d2-a260-2ac81691f73a&cat=en_US_671e06d0-f20d-4bb3-9c6a-42c825ddb1dc&lang=en&cr=US&sloc=&p=1 |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-10-18 : 11:34:25
|
| Not Necessarily. If col1 has unique or selective records you should have Clustered index on col1 as it stores all informations for indexes and makes things faster. |
|
|
|
|
|
|
implementation index