, 2004 2:01 PM
To: [EMAIL PROTECTED]
Subject: Re[2]: Index not functioning
Hello Jack,
Wednesday, March 24, 2004, 6:50:45 PM, you wrote:
JC> I tried using 'USE INDEX' and 'BETWEEN' but it didn't change anything.
JC> EXPLAIN SELECT counter, UNIX_TIMESTAMP(dtime)
Hello Jack,
Wednesday, March 24, 2004, 6:50:45 PM, you wrote:
JC> I tried using 'USE INDEX' and 'BETWEEN' but it didn't change anything.
JC> EXPLAIN SELECT counter, UNIX_TIMESTAMP(dtime) FROM ifInOctets_137
JC> USE INDEX (dtime) WHERE id=2809 AND dtime BETWEEN FROM_UNIXTIME(107397)
JC> A
