There are indexes on all of the timestamps now. Originally, the index
for cal_quat_1.timestamp was missing but cal_quat_2.timestamp was
created with the table.
On 19 Feb 2004, at 15:04, Martijn van Oosterhout wrote:
> On Thu, Feb 19, 2004 at 01:23:34PM -0500, Randall Skelton wrote:
>> The main problem was that there wasn't an index on cal_qat_1. The
>> other indexes were fine so I don't know what happened to the first
>> one...
>
> How about an index on cal_quat_2.timestamp?
>
> Hope this helps,