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 |
Explain about the multi-provider in the sap?
What are the server related tuning?
what is type of transfer in transfer rules...
What is the namespace of BW?
I told my process chains nearly 600 are there he asked me how can u monitor I told him I will see in rspcm and bwccms he asked is there any third party tools is there to see? Any tools are there to see tell me what it is
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?
Where do you store custom style sheets?
how can u correct the error in loading for Delta failure
2 Answers Cap Gemini, Cognizant,
Is it possible to create aggregates for cumulative?
What is sap bw/bi? What is the purpose of sap bw/bi?
what is diffarences between QUEUE DELTA & DIRECT DELTA.
How many extra partitions are created and why?