Results 1 to 4 of 4
  1. #1
    Xavier Houppertz Guest

    Answered: slow table in database

    hello,

    I have a database with 20 tables. When querying, one has suddenly become very slow. It is the biggest one (100.000 rows, 17MB).

    Any ideas ?
    Xavier

  2. Best Answer
    Posted by Bret Halford

    "Have you followed the general investigation steps discussed in the whitepaper on analyzing and resolving optimizer problems at http://my.sybase.com/detail?id=2602?

    bret"


  3. #2
    Brian Ceccarelli Guest
    If it has "suddenly" become really slow, you must do an
    Code:
    update all statistics TABLENAME
    This will fix you up!

    You need to update your statistics on all your tables often--at least once a week.

    Brian

  4. #3
    Bret Halford Guest
    Have you followed the general investigation steps discussed in the whitepaper on analyzing and resolving optimizer problems at http://my.sybase.com/detail?id=2602?

    bret

Posting Permissions

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