Re: simple sql optimize help/mlml

From: Sybrand Bakker <gooiditweg_at_sybrandb.verwijderdit.demon.nl>
Date: Fri, 18 Jun 2004 19:26:12 +0200
Message-ID: <8b96d0d4ejmsk4sepbl2u7eq1r96g1ok4u@4ax.com>

On 18 Jun 2004 17:08:23 GMT, ae299_at_FreeNet.Carleton.CA (Michel Lee) wrote:

>What can i do to improve on the speed without using concatednated indexes
>create index userlogdate_ix on ws_log
> (user_id,log_date) tablespace websenseixts NOLOGGING;

Not much apart from posting the explain for the original query, which you for some reason left out.
Other than that 'indexing every column is beneficial for performance' is of course a fairy tale.

--
Sybrand Bakker, Senior Oracle DBA

Received on Fri Jun 18 2004 - 12:26:12 CDT