minpctused

[hikums]

specifying the minpctused on the create index statement may have the
most negative performance impact on what operation,
insert/delete/update/select? Thanks for the response.

[Mark A]

<hi****@gmail.com> wrote in message
news:11**********************@g10g2000cwb.googlegr oups.com...

specifying the minpctused on the create index statement may have the
most negative performance impact on what operation,
insert/delete/update/select? Thanks for the response.

That is a good question. My guess is insert, because it reduces amount the
free space on a page to place new index rows.

[hikums]

Thanks Mark.