questionn on sql ?

[Former Member]

A developer used the max_row_per_page configuration set to 50% to apred out the data of a 500 MB table.His boss thought this was a waste of space since the table now took up 1000MB.Why would someone do this?

The same developer created an index on the table using fill_factor of 50%.This caused the index to use twice as many index pages.Why would he do that?

[Former Member]

Hi,

Are you working on SYBASE database ?

you may post it there...

[lbreddemann]

Hi there,

what the heck is the "max_row_per_page configuration" ??

I'm pretty sure that I know quite a bit about segment storage option in Oracle, but this setting is totally new to me.

Could it be that you mean something like PCTFREE/PCTUSED?

Usually one might think on trying to influence such low level storage to archieve things like less locking contention on a single block or to avoid chained rows.

Anyhow, with the advent of ASSM the need for such action has greatly decreased.

regards,

Lars

[markus_doehr2]

Why not ask the developer why he did that?

Markus