p.idmembre=t.idmembre
limit 5;
(I currently have idmembre as an index on tmp_stat and prefs)
How does DISTINCT work ? Is this a bug or a misconfigured index ?
--
Jean-Christophe Boggio
[EMAIL PROTECTED] -o)
Independant Consultant and Developer
22
seconds.
Is there a way to optimize this ?
(REASON is indexed though I can see no interest in this query.)
TIA!
--
Jean-Christophe Boggio
[EMAIL PROTECTED]
Independant Consultant and Developer
Delphi, Linux, Oracle, Perl
e fractionnal part is the
portion of the day (although I don't know --yet-- how to convert
date2-date1 to an integer, trunc does not work).
HTH
--
Jean-Christophe Boggio
[EMAIL PROTECTED]
Independant Consultant and Developer
Delphi, Linux, Oracle, Perl
