What would be a good strategy in adding indexes to the various tables? I know SQLite can only use one index in simple (not intersect etc.) queries, so is it usually best to make: - indexes that include all possible combinations of fields that may appear in a WHERE clause. - make one very large index combining all fields that may appear in a WHERE clause.
Or would it be better to make single field indexes and go with intersect etc? I understand that in the end it will come down to a lot of experimenting, but maybe there are some useful guidelines/rules that speed up this large task. RBS ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
