Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2005
    Posts
    26

    Unanswered: tables and rowcounts

    How can I get a list of tables that have a rowcount > 100,000 in DB2 UDB?

    CougarTrace

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Provided that you have current statistics:

    SELECT TABSCHEMA, TABNAME FROM SYSCAT.TABLES WHERE CARD > 100000

  3. #3
    Join Date
    Oct 2005
    Posts
    26

    Thanks

    Thanks for the information!

    CougarTrace

Posting Permissions

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