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 |
|
WoodHouse
Posting Yak Master
211 Posts |
 Posted - 2009-07-21 : 23:27:22
|
| HiI am a fresher of SQL SERVER. Please any one explains me when Index scan will occur and when index seek will occur and why...I have table like thisEMP_ID --Clustered IndexEMP_NAME --Non Clustered IndexEMP_CITY EMP_COUNTRY |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2009-07-22 : 04:04:43
|
| You might want to read this:http://www.sqlteam.com/article/sql-server-indexes-the-basics |
 |
|
|
WoodHouse
Posting Yak Master
211 Posts |
Posted - 2009-07-22 : 07:33:59
|
| HiMy question is what condition I will get Index Seek & scan.. |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2009-07-22 : 08:12:23
|
| If you read the link, you might work it out for yourself. As you are a fresher, you are supposed to use your resources to find the answer yourself, therefore either read the link or try http://www.justfuckinggoogleit.com |
|
|
|
|
|
|
INDEX