What is Table partitioning? What are Return Tables?

A) If we have Calmonth or Fiscper as time characteristic, then we can partition the fact table physically. Table portioning has to be supported by the Database. Oracle, Informix, IBM DB2/390 supports table partitioning. SAP DB, Microsoft SQL Server IBM DB2/400 does not support table portioning. Table partitioning helps to run the report faster as data is stored in the relevant partition.
B) In Update rule routine, If we want to return multiple records, instead of single value, we can use this return table.

0 comments: