Re: SQL

From: Mladen Gogala <mgogala_at_allegientsystems.com>
Date: Thu, 30 Jun 2005 08:49:03 -0400
Message-ID: <42C3EA3F.6090803@allegientsystems.com>

Vishal wrote:

>this is using all the appropriate indexes and everything.. is there
>something or can you suggest something which will help me to improve
>this?
>
>
>

CREATE BITMAP INDEX MLADEN_SAID_SO
ON AC_INTERNAL_ACCOUNTS(ACCOUNT_CATEGORY_CODE) TABLESPACE SYSTEM; This assumes that you have whole lot of accounts and quite a few categories.

-- 
Mladen Gogala
Oracle DBA
Ext. 121


--
http://www.freelists.org/webpage/oracle-l

Received on Thu Jun 30 2005 - 14:39:11 CDT