Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2003
    Posts
    3

    Smile Unanswered: table extent size ???? help me

    Hello,

    I would like to know how to calculate extent size of a table with the size of the table, the size of index and the number of rows.
    The size of the page is 2048.
    What is the magic formula?

    Thank you very much.

  2. #2
    Join Date
    Aug 2002
    Location
    Belgium
    Posts
    534
    The extent size of the index will be calculated for you. It depends on teh size of the table etc.
    You get the best performance if you don't have more tahn 8 extents per table.
    rws

Posting Permissions

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