What is table partition?
Answers were Sorted based on User's Feedback
Answer / hari
partitioning enables the query to fetch the data
parallelly. if the query requires 12months of data and the
partition is based of 0calmonth, the query fetches the data
in 12 parallel processes, thery by reducing the time for
query output by 12 times in theory.
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / vsu_vnaya
Table partioning is required for the better query
performance, as the Infocube contains huge data and want to
query on a particular period then it is performed, Table
partitioning is done based on 0FISCPER or 0CALMONTH. And it
is a virtual or logical partioning of data.
Is This Answer Correct ? | 3 Yes | 0 No |
What is a cell editor?
What is the monitor transaction?
What is the library?
What are the delta modes available?
Describe transfer rules?
Describe the new BW 3.x authorizations?
How are security issues debugged?
How to create an info set with info cube?
How would you do the optimizing the dimensions
1.what is exception aggregation? 2.difference between condition and filter 3.difference between direct update dso and write optimized dso? 4.difference between repeat and repair process types? 5. disadvantage due to numeric pointer in generic extraction?
What is the purpose of geographical information in the sap bw?
How does the query calculated?