Re: index on separate physical disk
From: arthur (alangham_at_gmail.com)
Date: 02/23/05
- Next message: Bart Duncan [MSFT]: "RE: collation"
- Previous message: Sgt. Sausage: "Re: Do views have any performance advantages?"
- In reply to: Andrew J. Kelly: "Re: index on separate physical disk"
- Next in thread: arthur: "Re: index on separate physical disk"
- Reply: arthur: "Re: index on separate physical disk"
- Messages sorted by: [ date ] [ thread ]
Date: 23 Feb 2005 13:25:52 -0800
well, we've got several huge tables, and queries against them that are
suffering from poor performance. both data and indexes are on a single
raid 0+1 drive. we've got several bays left in our disk array, and i'm
wondering if moving the indexes to their own raid 0+1 or raid 5 drive
will increase performance ( - in oracle this is a no brainer). you can
assume that the queries and indexes themselves are optimized.
- Next message: Bart Duncan [MSFT]: "RE: collation"
- Previous message: Sgt. Sausage: "Re: Do views have any performance advantages?"
- In reply to: Andrew J. Kelly: "Re: index on separate physical disk"
- Next in thread: arthur: "Re: index on separate physical disk"
- Reply: arthur: "Re: index on separate physical disk"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
