[rt-users] Performance Increase through Indexing...

[Vivek Khera]

>>>>> "DCT" == David C Troy <dave at toad.net> writes:

DCT>   - Iterate through Attachments to see if there are any "orphan"
DCT> attachments; if so, delete them
DCT>   - Iterate through other tables for orphaned objects

Ideally, these issues are avoided via foreign keys.  But the MySQL
authors know better than us users that this feature is unnecessary ;-(

Really, the only way to find out what keys are necessary is to
evaluate all the queries you do, and determine which ones are most
often done.  Not all queries need to have an index on the search keys,
especially if it is not done often.  This is your traditional space
vs. time tradeoff.