Questions in Building Indexes

From: Victor <lch_1_at_hotmail.com>
Date: Wed, 27 Jun 2001 22:26:22 +0800
Message-ID: <9hcq4s$qo56@imsp212.netvigator.com>

Dear All,

I got some questions in the topic Indexes:

Why Bitmap index is good for queries often use a combination of multiple WHERE conditions invloving the OR operator?

Why using a few standard extent sizes that are mulitples of 5 xDB_BLOCK_SIZE can minimize fragmentation?

Why bitmap index cannot be unique?

can I modify the PCTFREE and PCTUSED parameter of INDEX?

Are there two methods of rebuilding index? Offline and online modes? Is that Specifying 'Online' in the statement means rebuild in online mode? and omit it means offline mode?

Thx a lot Received on Wed Jun 27 2001 - 09:26:22 CDT