Re: bitmap index

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;

-- 
http://www.mgogala.com