Partitioning

[Former Member]

hai all,

<b>What is Partitioning? On what Characteristics we can perform partition...</b>

thanks in advance

from

prashanth

[Former Member · Accepted solution]

Hi,

Table partitions are physically separated tables, but logically they are linked to one table name. PSA tables and non-compressed F-fact table are partitioned by the system (by request ID). The (compressed) E-fact table can be partitioned by the user by certain time characteristics. For range-partitioned InfoCubes, the SID of the chosen time characteristic is added to both fact tables.

When using range partitioning, query response time is generally improved by partition pruning on the E fact table: all irrelevant partitions are discarded and the data volume to be read is reduced by the time restriction of the query. Note that all F fact table partitions have to be read.

hope it helps

VC

[Former Member]

hi shanthi,

visit these links, u wil get to know abt partitioning...

http://help.sap.com/saphelp_nw04s/helpdata/en/33/dc2038aa3bcd23e10000009b38f8cf/content.htm

http://help.sap.com/saphelp_nw04/helpdata/en/e0/b60b404b2b1e07e10000000a1550b0/content.htm

regards

shameem

[Former Member]

Hi

Partioning:

The basic idea behind database partitioning is to split a physical table and its indexes into several smaller physical tables and indexes.

fact table partioning is used to improve performance.

partioning can be done on 0CALMONTH & 0FISCPER

CHEERS

Shiva

Message was edited by: Shiva Shankar