Re: SQL hints/ways of enhancing sort/GROUP BY queries...

From: Domenic G. <domenicg_at_hotmail.com>
Date: 18 Sep 2003 08:18:58 -0700
Message-ID: <c7e08a19.0309180718.7e7c7fd9@posting.google.com>

In some cases, the ORDER BY can use an index, but I would need to see a specific example.

You can also use simple aggregate materialized views that are refresh on commit ...

For example:

CREATE MATERIALIZED VIEW LOG ON any_table WITH PRIMARY KEY etc etc (can't remember exact syntax)

then ...

CREATE MATERIALIZED VIEW ...
REFRESH FAST ON COMMIT
...

SELECT <see docs for restrictions on select list>

GROUP BY ... Hope this helps ...

Domenic.

spendius_at_muchomail.com (Spendius) wrote in message news:<aba30b75.0309180158.3c65f399_at_posting.google.com>...
> Hi,
> I'd like to know if someone knows how to specifically
> tune queries involving sorts and/or using GROUP BY functions.
> Are there particular hints for that purpose ? Apart from
> playing with the sort area size, do you know any other
> feature or way of improving this category of queries ?
>
> Thanks.
> Spendius
Received on Thu Sep 18 2003 - 10:18:58 CDT