ssage -
From: "Erlend Stromsvik" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, August 06, 2001 10:53
Subject: slow and fast query problem
> Hi
>
> (I hope I'm not asking to many 'stupid' questions... :)
>
> This query runs very fast
Hi
(I hope I'm not asking to many 'stupid' questions... :)
This query runs very fast (time 0.01 seconds):
SELECT * from DB_GNIST.varer WHERE kategori = 24010 ORDER BY utgivelses_aar
DESC LIMIT 10;
This one is slow (time 0.73seconds):
SELECT * from DB_GNIST.varer WHERE kategori = '24010' ORDER B