what are the disadvantages of INDEXES?
Moderator: General Moderators
what are the disadvantages of INDEXES?
what are the disadvantages of INDEXES?
- Chris Corbyn
- Breakbeat Nuttzer
- Posts: 13098
- Joined: Wed Mar 24, 2004 7:57 am
- Location: Melbourne, Australia
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).
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.
- Chris Corbyn
- Breakbeat Nuttzer
- Posts: 13098
- Joined: Wed Mar 24, 2004 7:57 am
- Location: Melbourne, Australia