Hi Hannes
Several approaches to achieve your work. One is upgrade your resource i.e.
CPU, memory... I do not take this. Another is check all columns used inside
WHERE clause whether they are indexed. If not, pls create indexes for them.
it will definitely smooth better.
Programmatically, I
PROTECTED]; [EMAIL PROTECTED]
Subject: RE: Very (excruciatingly) slow select
Hi Hannes
Several approaches to achieve your work. One is upgrade your resource
i.e.
CPU, memory... I do not take this. Another is check all columns used
inside
WHERE clause whether they are indexed. If not,