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]

Reply via email to