| | Index
Posted By: Posted Date: September 21, 2010
Points: 0 Category :Sql Server | |
|
|
Hi
Table2 like master table and total records is 60491
Table1 is detail table and total records is 56087
No index both the tables
SELECT A.*,
b.*
FROM dbo.Table1 a
LEFT OUTER JOIN dbo.table2 b
ON a.Number=b.Number
and source = @source
Please advice which index is good practice. please advice why we need to use
Thanks a Lot friends
View Complete Post |
| More Related Resource Links |
| | | |
|