Re: help getting cost down in plan table?



bbulsara23@xxxxxxxxxxx wrote:
Thanks Daniel. We have stats gathered everynight through a scheduled
job. My test system was created today and the job hadn't run yet. I
created the stats manually and the indexes are now being used. Thanks
for pointing out the obvious, which wasn't so obvious ;)
Regards
Barry

And thanks for NOT pointing out my abyssmal job of editing what I wrote
leaving it with grammar equal in value to that of my cat.
--
Daniel A. Morgan
http://www.psoug.org
damorgan@xxxxxxxxxxxxxxxx
(replace x with u to respond)
.