Navigation

    • Register
    • Login
    • Search
    • Categories
    • Recent
    • Tags
    • Popular
    • Users
    • Groups
    • Search

    Incorrect "Excess TblRSz" and "Excess IdxRSz"

    ~~Bugs~~
    2
    22
    11466
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • tom
      tom administrators last edited by

          ┌─────────────────────────────── Table and Index Range Information ────────────────────────────────┐
          │                                                                                                  │
          │                          -basetable:       1                           -baseindex:       1       │
          │                     -tablerangesize:      50                      -indexrangesize:      50       │
          │                                                                                                  │
          │                Highest Stats Table#:      50                 Highest Stats Index#:      50       │
          │             Lowest Monitored Table#:       1              Lowest Monitored Index#:       1       │
          │            Highest Monitored Table#:      25             Highest Monitored Index#:      50       │
          │                                                                                                  │
          │                                   Application Tables and Indexes                                 │
          │                                                                                                  │
          │         Actual Number of App Tables:      25         Actual Number of App Indexes:      55       │
          │                  Minimum App Table#:       1                  Minimum App  Index#:       8       │
          │                  Maximum App Table#:      25                  Maximum App  Index#:      62       │
          │              Unmonitored App Tables:       0              Unmonitored App Indexes:      12       │
          │                                                                                                  │
          │                  Excess Table Range:      24                   Excess Index Range:     -12       │
          │                                                                                                  │
          │              Minimal App -basetable:       1               Minimal App -baseindex:       8       │
          │         Minimal App -tablerangesize:      25          Minimal App -indexrangesize:      55       │
          │                                                                                                  │
          │                Suggested -basetable:       1                 Suggested -baseindex:       8       │
          │           Suggested -tablerangesize:      75            Suggested -indexrangesize:     104       │
          │                                                                                                  │
          │                                   System Tables and Indexes                                      │
          │                                                                                                  │
          │                       Lowest Table#:    -361                        Lowest Index#:  -1,610       │
          │                      Highest Table#:      25                       Highest Index#:   1,093       │
          │                                                                                                  │
          │       Suggested Complete -basetable:    -361        Suggested Complete -baseindex:  -1,610       │
          │  Suggested Complete -tablerangesize:     436   Suggested Complete -indexrangesize:   2,753       │
          │                                                                                                  │
          │                                                                                                  │
          │  * "System" tables and indexes include the meta-schema but do not count psuedo tables such       │
          │    as VSTs and SQL views as these do not have any CRUD statistics associated with them.          │
          │                                                                                                  │
          └──────────────────────────────────────────────────────────────────────────────────────────────────┘
      
      1 Reply Last reply Reply Quote 0
      • Rob Fitzpatrick
        Rob Fitzpatrick last edited by

        Nice. 🙂

        1 Reply Last reply Reply Quote 0
        • First post
          Last post