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 |
|
kid_on_the_block
Posting Yak Master
172 Posts |
 Posted - 2006-02-07 : 06:48:55
|
| Can we say that if there are 4 tables that are joined , the query will definately take a longer time to execute, can we still reduce the execution timeI mean how can u still further optimize the performance , or say that the performace can no further be done on the particular job |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2006-02-07 : 08:04:30
|
| >>the query will definately take a longer time to executelonger than what?That is a pretty general question so here's a general answer:The more complex the statement, the more possibility there is to find a faster execution plan. But at some point for a given request against a given set of tables (and row values) the plan will be about as good as can be expected and duration will not be able to improve (much). Are you having a particular problem with performance?Be One with the OptimizerTG |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
kid_on_the_block
Posting Yak Master
172 Posts |
Posted - 2006-02-07 : 22:32:22
|
| Yess , performance issues. Now i cant figure it out the DB also has some hitorical data, what is actually done to the historical data, is it good to shift it to another server or something of that sort. |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2006-02-08 : 05:31:52
|
| That would depend on if the historical data is reported on or if you have an obligation to keep the data for a certain amount of time otr if your company wanted to do year on year comparisons etc.. |
|
|
|
kid_on_the_block
Posting Yak Master
172 Posts |
Posted - 2006-02-08 : 07:10:09
|
| Thanks, needed some tips as to from where do I start perfromance tuning of a sql server.Some steps to go about. |
|
|
|
|
|
|
SQL Queries