Re: Specifying multiple WHERE options within a group?

[Callum Macdonald]

Hi Jay,

Thanks again for your help on this.

The TrackingActions table has a number of other fields as well, and the ID is a primary key, at least as far as I'm aware.

mysql> EXPLAIN TrackingActions;
+---------+--------------+------+-----+---------------------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------+--------------+------+-----+---------------------+----------------+
| ID | int(11) | | PRI | NULL | auto_increment |
| UserID | varchar(6) | | | | |
| Action | varchar(25) | | | | |
| Page | varchar(40) | | | | |
| Time | datetime | | | 0000-00-00 00:00:00 | |
| IP | varchar(15) | YES | | NULL | |
| Host | varchar(255) | YES | | NULL | |
| Browser | varchar(255) | YES | | NULL | |
| Notes | text | YES | | NULL | |
+---------+--------------+------+-----+---------------------+----------------+
9 rows in set (0.00 sec)

I understand about Primary Keys, but what additional indexes are you suggesting I add? I don't know what you a "reverse index" is. Happy to add the indexes if it'll make the queries quicker though.

Cheers - Callum.