Re: Performance difference issue between two users of the same database

AK_TIREDOFSPAM_at_hotmail.COM wrote:
> Just one more possibility:
>
> even if you have exactly the same data in both schemas, the physical
> order of rows could be different. So similar indexes might have very
> different clustering factors.
> Hence different execution plans. In this situation even if you force
> the optimizer to choose one and the same plane on both schemas, you'll
> heve very different real execution costs.

Thanks a lot for the help. Yeah , thsi is correct that physical order of the rows can cause different execution pland and even we can know which one plan is best, but for sure we can say that the response time of both the users should not have 10% difference. In my case one user executes the query in 30 seconds while other in 180 seconds, This difference is unbearable. So please tell me the steps for avoiding such a great difference....... Received on Sat May 28 2005 - 03:47:21 CDT