Re: bitmap index

From: Rob Zijlstra <rj.zijlstra_at_tiscali.nl>
Date: Thu, 24 Nov 2005 07:10:42 +0100
Message-ID: <v9mao1528vhj16b9tuprh0hqrs594cr9b8@4ax.com>

On Wed, 23 Nov 2005 13:11:34 -0800, DA Morgan <damorgan_at_psoug.org> wrote:

>Mladen Gogala wrote:
>> On Tue, 22 Nov 2005 17:43:05 -0800, lsllcm wrote:
>>
>>
>>>I have a table T1 has columns FNAME, MNAME, LNAME, STATUS and other
>>>columns, the value of T1.STATUS is 'Y' or 'N'. The requirement is to
>>>retrieve the table from these four columns, How to create index is the
>>>right way?
>>
>>
>> create index THE_RIGHT_WAY on T1(FNAME, MNAME, LNAME, STATUS)
>> tablespace SYSAUX;
>
>In SYSAUX? You've got to be kidding.

I assume you don't know our friend Mladen? Best Regards

Rob Zijlstra Received on Thu Nov 24 2005 - 00:10:42 CST