Re: side effect of compound index

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 19 Apr 2006 18:17:42 -0700
Message-ID: <1145495862.388490.297900@g10g2000cwb.googlegroups.com>

Anne, what side effect are your experiencing, or are you asking about possible side effects?

The presence of a new index will give the CBO some new options which may result in some plans changing. But the odds are in your favor that the new index will not hurt you as much as it helps.

The replacing of a 3 column bit-map index with a 4 column btrieve index will result in more space being used to hold the index, but it will imporve the ability of Oracle to process multiple concurrent updaters to the table.

HTH -- MArk D Powell -- Received on Wed Apr 19 2006 - 20:17:42 CDT