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 |
|
asad.lte
Starting Member
32 Posts |
 Posted - 2010-05-12 : 05:13:26
|
| Hi Experts,i need ur support ,see i hav a big query which is taking around 22 min to get execute.now m adding some extra logic to tht query to get my output but still it is taking much time than expected.my superiors said it is effecting our server and making performance slow.i was asked to write a index to avoid this problem hope u guys got wat m expecting. thanx in advance |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-05-12 : 05:24:00
|
Speeding up a query without knowing the table structure and the used query is not possible for us.If you want help on this you have to spend YOUR time on giving the needed information.- table structure and indexes- sample data- needed output- execution plan- maybe number of rows in the tables- SQL Server version!!
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-05-12 : 05:24:51
|
Ah! And your actual query!
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
|
|
|
Index Creation