Whatīs the point of seperate index and data if...
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Whatīs the point of seperate index and data if...

  1. #1
    Join Date
    Oct 2000
    Posts
    139
    If we use RAID 0+1, wouldnt striping be enough instead of seperating indexes and data in two different tablespaces??? They will be stored in different disks anyway no?

  2. #2
    Join Date
    Jul 2000
    Posts
    53
    What is the question here?

    The datafiles will be spread onto multiple disks (striped) yes, however this does not stop fragentation at the tablespace level and does not conform to OFA.

    So although you probably won't see a performance increase by seperating them out it is a standard.
    Steve

  3. #3
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    Tablespace Fragmentation depends on OS fragmentation so itīs not really an issue here, I think i wouldnt care about database fragmentation anymore for those tables which wont be scanned fully for a query.

    Seperating indexes and data in Raid 0+1... I dont see much point in perfomance issue except that itīs probably easier to administer otherwise we could just have everything in one tablespace (everything!) :D

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Placing tables and indexes in seperate tablespaces will reduce I/O contention and thus result in better performance regardless of the RAID level. Index and Data tablespaces typically reside on different mount points. These mount points are groups of physical disks. Yes, if you place a datafile on a 0+1 device, it will be stiped across x number of disks. However, if you put a datafile for the data tablespace on one set of 0+1 disk and your index tablespace datafile on another set of 0+1 disk, you have two sets of disks spinning during a query instead of just one. In an ideal world, these to filesystems would be controlled by two different disk controllers.

    0+1 is just a disk technology. As a DBA you must always think of disk resource as a single disk to eliminate I/O contention. In this situation you have to ask yourself, "Would I put my data and indexes on this disk if it were a single 9G 5400RPM drive?"
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

Posting Permissions

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



Click Here to Expand Forum to Full Width