Re: Tuning group by sql

Kevin,

From the sarcastic tone of your response I gather you did not find my advice useful. Fair enough. The use of the ANALYZE command is something most people not new to Oracle will know about. However, there was nothing in your question indicating your level of experience. You should keep in mind that no one is obligated to try to solve your problems. You have the option of ignoring those responses that do not apply to your situation. If, instead, you react rudely to well-intentioned advice, you may find that people will choose not to respond.

On Fri, 18 Feb 2000 18:17:58 GMT, kevinator_ca_at_my-deja.com wrote:

>Whoa, I've never noticed this analyze command before. What exactly does
>it do. I'm looking at the sql reference for it now. I see that it
>collects statistics on the table but why would I want to do that.
>Please give my an example of how this might improve performance and
>under what circumstances it is useful. Your help is appriciated.
>
>kevin
>
>In article <38ab780b.44967551_at_news.metro.net>,
> mis1965_at_yahoo.com wrote:
>> Kevin,
>>
>> Have you run the ANALYZE command on the table and its indexes? Maybe
>> Oracle is using the rule-based optimizer because statistics aren't
>> available. HTH
>>
>> Mike S.
>>
>> On Tue, 15 Feb 2000 21:32:07 GMT, kevinator_ca_at_my-deja.com wrote:
>>
>> >Hello Ora-People,
>> > I'm using oracle 8i. I have a query that scans a large table
>(about
>> >100,000 and growing daily) The query uses a GROUP BY clause. When I
>do
>> >the explain plan, I noticed that my indexes aren't being used at
>all. I
>> >have two fields in the group by clause, i created 3 indexes, one with
>> >for each field and one for the combination of the two but nothing. If
>> >anyone know the best way to the best way to tune a query group by
>> >clause, please let me know.
>> >
>> >Kevin English
>> >
>> >
>> >Sent via Deja.com http://www.deja.com/
>> >Before you buy.
>>
>>
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Sun Feb 20 2000 - 15:51:53 CST