Re: Include all columns in an unique index

[Mark A]

"Henry J." <tank209209@yah oo.comwrote in message
news:0b777fe4-ebe0-4994-9c16-defafb665a61@f3 6g2000hsa.googl egroups.com...

To benefit from putting all columns into "include", what should I ask
our DBAs to do? Increate table space? Bufferpool? Please advise.
>
>Thanks!

It probably will help your select performance, but it will take up more disk
space (which I assume you are OK with).

[Henry J.]

Re: Include all columns in an unique index

On Sep 28, 10:58 pm, "Mark A" <some...@someon e.comwrote:

"Henry J." <tank209...@yah oo.comwrote in message
>
news:0b777fe4-ebe0-4994-9c16-defafb665a61@f3 6g2000hsa.googl egroups.com...
>

To benefit from putting all columns into "include", what should I ask
our DBAs to do?  Increate table space? Bufferpool?  Please advise.

>

Thanks!

>
It probably will help your select performance, but it will take up more disk
space (which I assume you are OK with).

Thanks. I guess the insertion will be slower, right? Let me test it
out.

[Henry J.]

Re: Include all columns in an unique index

On Sep 28, 10:58 pm, "Mark A" <some...@someon e.comwrote:

"Henry J." <tank209...@yah oo.comwrote in message
>
news:0b777fe4-ebe0-4994-9c16-defafb665a61@f3 6g2000hsa.googl egroups.com...
>

To benefit from putting all columns into "include", what should I ask
our DBAs to do?  Increate table space? Bufferpool?  Please advise.

>

Thanks!

>
It probably will help your select performance, but it will take up more disk
space (which I assume you are OK with).

Thanks. I guess insertion will be slower, right?