Re: Set Explain with SP's

CRAIG@CHEMISTRY.CHEM.UTAH.EDU wrote: > Now, with that said, here's a warning. Don't put all of your faith >in the output. I was burned once when I accidentally used a CHAR >variable in a select against an integer column. The set explain said >that it would use my index. However, when the time actually came, >the database was clever enough to realize that it couldn't use the >index with my CHAR variable. So, it did a sequential scan instead; >contrary to what the set explain predicted. Oh sure, it was my fault. >But, I wish I hadn't placed all my faith in the set explain's output... Also keep in maind that whenever you update statistics the stored prcedures are reoptimised again. Hence your access paths can change. Regards, Rafal. Czerniawski DATASPACE CONSULTING PTY LTD