What is table partition?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

I have cube.for cube data coming from 3dso's.in one dso having special chars.in cube you got special char error.how u can resolve this?

1392


What is the process chain?

521


What are the added features in 3.x for multi provider?

1501


what are the drawbacks of cubes?

587


What does the program RSMDCNVEXIT check?

2077






How the dimensions are optimized?

497


What is automatic loading of similar/identical requests option?

1537


What is the use of transformation and how the mapping is done in bw?

508


What are the built in javascript functions available to customize your web template?

1474


What is a dashboard in sap bw?

503


Can you add programs in the scheduler?

554


What are the steps to create classes?

1630


How do you debug user exit?

1477


Is it possible for the users to convert the package group into a process chain? If so, how?

493


what are the reports used from business content in sap bw project?name them and what was the requirement?

2438