Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2005

    Unanswered: separate indexes

    Hi all.

    What performance benefits brings seperate indexes from their tables?
    I mean, putting indexes into different dbspaces as tables (non fragmented).


  2. #2
    Join Date
    Nov 2004
    If the two dbspaces are on seperate physical disks then you have two sets of hardware compared to at the moment.

    By improving the disk subsystem and say moving to fragmented indices update statistics can be improved dramatically.

    I am sure others far more experienced than I could give many more reasons.

Posting Permissions

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