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 the importance of 0requid?
What is the use of setup table?
How do you handle language dependent texts?
How to gathering the requirement
Where do you store your custom images (like logos)?
what is the use of routines?
Define a remote cube?
How is SAP BW different from SAS ( Statistical Analytical Software)?
how do u deceided to go create Aggregates for cube. what purpose u want to create aggregates?
what are the data types for the characteristics info object?
What is bw statistics and how it is used?
How many extra partitions are created and why?