DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: What is High Water Mark?

  1. 11-27-2000, 08:04 PM #1
    akhorram
    akhorram is offline Junior Member
    Join Date
    Mar 2000
    Posts
    39
    Hello everyone, can you please tell me what is High Water Mark? Thank you.
    Thanks,
    Afshin.
    Reply With Quote Reply With Quote
  2. 11-27-2000, 08:48 PM #2
    DBAtrix
    DBAtrix is offline Member
    Join Date
    Oct 2000
    Location
    Cambridge, MA (Boston)
    Posts
    144
    The biggest size any thing has been is a hi-water mark. Often used with respect to rollback segments and tables. E.G. If the table is 75M and once held enough records to get the 65M, even if there are no records now in the table (due to deletes), the HWM is still 65m.
    Reply With Quote Reply With Quote
  3. 11-28-2000, 07:17 AM #3
    TerryD
    TerryD is offline Member
    Join Date
    Sep 2000
    Posts
    128
    It's isgnificant since when you perform a full table scan it reads up to the high water mark... even if there isn't any data. This is often why a count(1) will perform better than a count(*).

    Terry
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width