Just one Dense Dimension

JanGLi

Hi,

Some of my data form weren't opening and during performance tunning i just kept my largest dimension as dense... and kept all other as sparse... and the order was from most members to least members... fortunately my forms started to work....

Just wanted to ask what effect will i have on my plan/application if i have just 1 dimension as dense?

Regards

JohnGoodwin

JanGLi wrote:Just wanted to ask what effect will i have on my plan/application if i have just 1 dimension as sparse?          

1 dimension as sparse you should check your block size after doing that.

Back to the fundamentals of block storage databases > https://docs.oracle.com/cd/E57185_01/EDBAG/understanding_multidim_dbs.html#dinconc28118

Cheers

John

JanGLi

Sorry it was a typo

it should be... Just wanted to ask what effect will i have on my plan/application if i have just 1 dimension as dense?

Regards