In the last episode (Jul 14), John Larsen said: > Hmmw your syntax should ork. Possibly try CREATE INDEX urlindex ON > internet_usage (time(8)); W 8hich will only use the first charaters > of your time field, it should make the index significantly smaller in > size.
A timestamp field is only 4 bytes as it is, and I don't think you can index part of it. -- Dan Nelson [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]