Ian Michael Gumby wrote:
>
>
>
>> From: DA Morgan <damorgan@psoug.org>
>
>> > Daniel, my client is using 9.
>> > When they go to either 10 or 11, then I'll go to 10 or 11.
>>
>> No attempt to change the subject. Your customer could be using
>> version 3.0 for all I care. My point is you are rendering an
>> opinion about a product based on knowledge of a version so old
>> it is in desupport.
>>
>> Would it make sense to comment on Informix based on an obsolete
>> version and extend that to apply to Cheetah? Of course not.
>>
>> PS: You might want to learn 10 and 11 in advance of your client's
>> need.
>
> Danny boy,
>
> Oracle 11 isnt due to be released until next month.
>
> So here we have it from the mouth of an oracle shill.
> If you want to run Oracle, you have to run the latest release, else the
> prior release is out of support.
>
> My client is on 9 and is looking at moving either to 10 or 11 next year.
> So running 9 is so out of date? GET REAL!
>
>
> Remember that there is a price/pain for moving to a newer release. At
> least with Oracle...
>


Have you tried UPDATE STATISTICS?