Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2003
    Posts
    8

    Unanswered: slow performance after move table

    After "alter table xxxx move tablespace new_tbs", the queries become slow.

    what has to be done after "move"? Analyze?

  2. #2
    Join Date
    Nov 2002
    Location
    Desk, slightly south of keyboard
    Posts
    697
    Hi,

    You need to rebuild the indexes and then analyze the table.

    Hth
    Bill
    Please don't email me directly with questions. I've probably just got home from the pub and cannot guarantee the sanity of my answers. In fact, I can't believe I actually made it home.

Posting Permissions

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