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 |
|
boreddy
Posting Yak Master
172 Posts |
 Posted - 2009-09-04 : 05:18:01
|
| In my database i have some table in these one table is main table it has the 16 Laces table, this table contain nearly 14 columns these columns are joined (nearly 10 columns)to one more table these joins are happening the based on the in parameter,when user selected all columns the main table joins to 10 times with other table on that time performance is fell downwhen i created index on main table it is not going to show any difference to that query executionplease suggest me for this thanks in advance |
|
|
ra.shinde
Posting Yak Master
103 Posts |
Posted - 2009-09-04 : 05:55:56
|
| Please give the table structures along with indexes and join query.Rahul Shinde |
 |
|
|
|
|
|
Performance issu