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 |
|
niranjankumark
Posting Yak Master
164 Posts |
 Posted - 2008-02-23 : 08:11:33
|
| Join made between Table A,B,C . based on one column i joined. logically i can join one column only. but Table A & b goes table scan (cost = 0%) , estimated row count 3 lakhs for bot, C Table has index scan row count is 4 lak.if table scan cost is zero mean anything harm ???Cost should be less for index and table scan ???? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-02-23 : 14:09:54
|
| If your tables are small, then the optimizer will typically choose to scan as it is the most efficient method for such tables. How big are your tables?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-02-23 : 16:05:46
|
3 lakh is 300000 records.What tkizer also mean is that it also depends on what you are indexing, the granularity.
E 12°55'05.25"N 56°04'39.16" |
|
|
|
|
|
|
Table scan cost %