Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 62 Insurance
- 536.1K On-Premises Infrastructure
- 138.2K Analytics Software
- 38.6K Application Development Software
- 5.7K Cloud Platform
- 109.4K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.2K Integration
- 41.6K Security Software
Just one Dense Dimension

JanGLi
Member Posts: 650 Bronze Badge
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
Tagged:
Answers
-
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
-
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
This discussion has been closed.