Re: Include all columns in an unique index

"Henry J." <tank209209@yahoo.comwrote in message
news:0b777fe4-ebe0-4994-9c16-defafb665a61@f36g2000hsa.googlegroups.com...

Quote:

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).

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

Quote:

"Henry J." <tank209...@yahoo.comwrote in message
>
news:0b777fe4-ebe0-4994-9c16-defafb665a61@f36g2000hsa.googlegroups.com...
>

Quote:

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

>

Quote:

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.

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

Quote:

"Henry J." <tank209...@yahoo.comwrote in message
>
news:0b777fe4-ebe0-4994-9c16-defafb665a61@f36g2000hsa.googlegroups.com...
>

Quote:

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

>

Quote:

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?

re: Re: Include all columns in an unique index