Re: SQL
- From: Mladen Gogala <mgogala@xxxxxxxxxxxxxxxxxxxx>
- To: mr.v.shah@xxxxxxxxx
- Date: Thu, 30 Jun 2005 08:49:03 -0400
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
- References:
- SQL
- From: Vishal
Other related posts:
this is using all the appropriate indexes and everything.. is there something or can you suggest something which will help me to improve this?
-- http://www.freelists.org/webpage/oracle-l
- SQL
- From: Vishal