View Single Post
  #7 (permalink)  
Old November 20th, 2006, 22:58
Shells Shells is offline
Junior Member
 
Join Date: Jun 2006
Posts: 24
Thanks: 0
Thanked 3 Times in 3 Posts
Groans: 0
Groaned at 0 Times in 0 Posts
Rep Power: 0
Shells will become famous soon enough
I do return rows (212 to be exact) both without because I changed everything you had named as TMS to be a domain we had in our system when I tested the query. It did run in about 30 seconds using the changes I gave you in the UI using the VPD. Without the VPD, in about 4. I wouldn't suggest running a query where no rows return in your db. You should at least use a date range where rows return as that is going to add to your timing.
Reply With Quote