Re: Query Performance Problem SE 5.06.UC1

tolis, } is facing following problem: } The optimizer doesn't select the appropriate index and the response time } varies from seconds to 30 minutes as also the no of rows found in the same } SQL statement. } The update statistics statement has been run. } The index is checked with bcheck with no problem. } set optimization low, alter index to cluster etc didn't have any effect } at all. } Why does the Optimizer not choose the right index ? } Has someone with this environment faced a similar problem ? check the OPTCOMPIND parameter in your onconfig file. most people recommend setting this to 0, but try setting it to 1 and 2 and see if you get any imporvement. i haven't had any problem with this, but some people have reported major performance differences by setting this variable. mickm