List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:July 14 2004 7:39pm
Subject:Re: do i need an index for this?
View as plain text  
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
	dnelson@stripped
Thread
do i need an index for this?J S14 Jul
  • Re: do i need an index for this?Dan Nelson14 Jul
  • Re: do i need an index for this?Justin Swanhart14 Jul
Re: do i need an index for this?J S14 Jul
  • Re: do i need an index for this?Dan Nelson14 Jul
  • Re: do i need an index for this?John Larsen14 Jul
    • Re: do i need an index for this?Dan Nelson14 Jul
Re: do i need an index for this?J S14 Jul