View Single Post
  #4 (permalink)  
Old February 14th, 2005, 04:42 PM
kBusby kBusby is offline
Registered User
 
Join Date: Jan 2005
Location: , , .
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I am not sure. Adding the Rule hint seemed to speed it up by a minute or so and I had one dba that may prevent a table scan. But with out the ability to analyse the query plan, I am not sure what effect this has.

Just looking for suggestions on whether there is a more effective way to structure the query.