Home » RDBMS Server » Server Administration » index compress
index compress [message #59232] Wed, 05 November 2003 09:09 Go to next message
Kapil
Messages: 145
Registered: May 2002
Senior Member
CREATE INDEX cust_dup_idx
ON customer(sex, hair_color, customer_id)
PARALLEL 35
NOLOGGING
COMPRESS 2;
In the above stmt what does Number "2" stands for in COMPRESS OPTION, why not 10 or 1 ? please help me.
thanks.

Report message to a moderator

Re: index compress [message #59233 is a reply to message #59232] Wed, 05 November 2003 11:05 Go to previous message
ctg
Messages: 146
Registered: July 2002
Senior Member
it stands for the 1st 2 columns of the index (sex, haircolor)

Report message to a moderator

Previous Topic: table partitioning
Next Topic: move tables out of system
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 10:42:12 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.