Microstrategy allows partitioning of data at the application level (logical level). This could be of great benefit to the access the data for the application. But I see an overahead of mapping of the partitions to the physical data.
Has applicaiton partitioning been a real advantage for...
Microstrategy allows reports data to be stored in physical tables through Data Marting.
Which all scenarios we require to store reports data into physical tables ?
What are the benefits of storing reports into physical tables ?
I believe that spool size also depends number of rows distributed on AMPs. If there is more skewing, then the joining with other table wud require more space which wud increase the actual spool required. The spool requirement can be tried through explain which estimates the number of rows for...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.