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 |
|
jscot
Posting Yak Master
106 Posts |
 Posted - 2010-06-11 : 16:56:21
|
| One question from all SQL Gurus!Let say we have EMPLOYEE Table and Fields are SSN#, EMPID, LNAME, FNAMESSN# IS PRIMARY KEY So Clustered index on SSN# right? Because Primary Key generate Clustered Index by defaultand my query is SELECT * FROM EMPLOYEEWHERE EMPID BETWEEN 1 AND 10This table carry Million record and we want to avoid table scan, What should we do? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
jscot
Posting Yak Master
106 Posts |
Posted - 2010-06-11 : 17:11:04
|
| Tara this is just a question that i had in my mind. But i have one question "Cluster index sort the data row ASC AND DEC order right?how about non clustered index? you know about "Natural Index"?I appreciate your Help!! |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
jscot
Posting Yak Master
106 Posts |
Posted - 2010-06-11 : 17:53:01
|
| Trying to refresh my memory!!! for Interview. |
|
|
|
|
|
|
Index Help