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 |
How can a cube have partitioned for which the data already exists?
How is amount/quantity different from number?
What is the new features of ODS after version 3.x?
What is info provider documentation?
What are tickets.
What are the template options?
Give an example of master data documentation?
How do you create event chains?
what is the use of attribute in the attribute
What is ?filling? of aggregate?
Can you compare the CO-PA to an info cube?
What is an infopackage?