Page 1 of 1
what are the disadvantages of INDEXES?
Posted: Fri Apr 20, 2007 12:51 am
by eshban
what are the disadvantages of INDEXES?
Posted: Fri Apr 20, 2007 1:13 am
by Chris Corbyn
You use more space because of the way the tree structures are stored internally. Your database will also take longer to initialize the tables upon initial startup and when restoring from backup. Don't index anything you don't need, mostly becuase as I say, it uses a lot more storage space (and memory if I remember correctly).
Posted: Fri Apr 20, 2007 3:39 am
by onion2k
For high insert and update volume tables, ones where records are added and changed many times every second, an index can have a negative impact on performance. Other than that though, indexes are pretty much always a good idea where you need a boost on selects. Just remember to lock your tables properly, and use transactions if they're available.
Posted: Fri Apr 20, 2007 6:30 am
by Chris Corbyn
onion2k wrote:Just remember to lock your tables properly, and use transactions if they're available.
Does this relate to indexes in any way?
Posted: Fri Apr 20, 2007 6:46 am
by onion2k
d11wtq wrote:onion2k wrote:Just remember to lock your tables properly, and use transactions if they're available.
Does this relate to indexes in any way?
Updating or inserting into an unlocked table increases the risk of corrupting the an index.