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 |
|
shannoncruey
Starting Member
1 Post |
 Posted - 2008-10-10 : 14:21:34
|
| Hi, I just need clarification on an argument we are having. Take a simple table (mybigfattable) with a composite PK, consisting of two columns - ID_A and ID_B.Now, say the mybigfattable has a zillion rows. If I do this sql:select * from mybigfattable xjoin myothertable y on x.ID_A = y.idWill it use the PK index or will it table scan?In this case do I need to create individual indexes for ID_A and ID_B if they are not referenced as a pair?Many thanks...S |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
When to Index...