Re: [GENERAL] query seems too slow

1999-11-03 Thread Timothy H. Keitt
uld have index both for tenstop.route_id and > history.route_id . From the index name, it not clear if you have > or not. No matter what, add indeces!!! > > >From: "Timothy H. Keitt" <[EMAIL PROTECTED]> > >To: [EMAIL PROTECTED] > >Subject: [GENERAL] quer

Indices (was Re: [GENERAL] query seems too slow)

1999-01-02 Thread Holger Klawitter
By the way, I've created a secondary index on a large table in order to gain some speed (the index is not unique), but the "explain" did not report any change. What else do I have to do to actually *use* an index? The manual only tells how to create one. FAQ? Regards, Holger Klawitte