Skip to Content
author's profile photo Former Member
Former Member

DB Statistics and BI Statistics

Dear Guru's,

Kindly explain

1. What is DB Statistics?

2. What is BI Statistics?

3. How are they different from each other.

4. Are they linked in any case?

Thanks, Dhruv

Add comment
10|10000 characters needed characters exceeded

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Apr 12, 2011 at 12:45 PM

    DB statistics

    Database Statistics is statistical data that get collected for database tables have information like no of rows are in each table, the number of distinct values that occur in a column etc. The database has a CBO (Cost Based Optimizer)which evaluates the queries user submit and uses the DB statistics to make decisions about which table to read first to optimize perofrmance.

    ex - join of multiple tables

    index to read the table

    sequential read of table.

    These statistical data is used by DBA to improve performance

    BW Statistics :

    It has information about queries, InfoCubes loads, compression etc .It is for basic functional areas of the Business Information Warehouse ( BW ).It is for recording and reporting system activity and performance.

    To see it you can use ST03 or ST03n transaction and can see various statistical data.These information come from RSDDSTAT table .It use 0TCT cubes for this .

    It will give you all info like run time of a query ,transaction used by a user ,loads related data etc .

    Some imp OSS notes for the same :

    422264, 309955, 551552

    For better understanding you can visit these links :

    http://help.sap.com/saphelp_nw04/helpdata/en/f2/e81c3b85e6e939e10000000a11402f/content.htm

    http://help.sap.com/saphelp_nw04/helpdata/en/19/f832ac5d4611d4aa1500a0c9430730/content.htm

    Hope you will find this information helpful.

    Regards,

    Jaya

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Dear Jaya,

      Thanks for sharing the knowledge. After reading all this my understanding about the topic is:

      DB Statistics contains data about the tables but what are those tables and where are they?

      BI Statistics records all the activities being held in SAP Systems, for this do we have to activate something for this and do we have to specify what to record.

      Brgds, Dhruv