Thread: Different execution time of query in two environment
View Single Post
  #3 (permalink)  
Old May 4th, 2009, 03:15 AM
elygp elygp is offline
Authorized User
  
Join Date: Oct 2006
Posts: 39
Thanks: 0
Thanked 0 Times in 0 Posts
Default Different execution time of query in two environment
Thanks for the reply old pedant..

My database is Sybase 15.0, regarding the indexes, I have checked the indexes of all tables used in the query and they are the same in dev and prod.

I have also tried using showplan and the results of the plan in the environment is also exactly the same. I still can't find what's causing the difference in execution time..