[@bobbyh Member 17 years, 2 months ago]

Note: if your DB is slow and you’d like to try this optimization, you must add the columns in the right order while making this multi-column index:

1. topic_status

2. forum_id

3. topic_sticky

4. topic_time

The order of the columns in the index needs to be the same as the order of the fields in your query, as explained here.