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.
--
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Wed Nov 23 2005 - 15:11:34 CST
