database usage statistics
Results 1 to 5 of 5

Thread: database usage statistics

  1. #1
    Join Date
    Feb 2012
    Posts
    2

    database usage statistics

    hi,
    I am looking for studies about statistics on database usage. These are the questions I am looking the answer for:

    1. What is the average amount of tables in an typical database?
    2. What is the average size of a record in a table?
    3. What is the typical frequency of INSERTs, SELECTs, UPDATEs and DELETEs ?
    4. What is the most used WHERE condition for SELECTs?


    I know it depends on the application, but there must be some statistics. Like the number of car accidents every country reports, it will be different for every country, but the statistics exist. For databases I can't find anything.

  2. #2
    Join Date
    Apr 2011
    Location
    Dallas, TX
    Posts
    38
    Have you ever reported any stats like that to some sort of agency that tracks info?

  3. #3
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,859
    What is the value of such statistics?. Numbers like car accidents are useful for insurance companies.

  4. #4
    Join Date
    Feb 2012
    Posts
    2
    Quote Originally Posted by skhanal View Post
    What is the value of such statistics?. Numbers like car accidents are useful for insurance companies.
    for me it will be useful for a development of a new database engine, to know which functions should I optimize for speed. Of course, if you are a user, you don't really care about this stuff

  5. #5
    Join Date
    Sep 2002
    Posts
    5,877
    Did Oracle ask those questions?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •