| 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 S | 14 Jul |
| • Re: do i need an index for this? | Dan Nelson | 14 Jul |
| • Re: do i need an index for this? | Justin Swanhart | 14 Jul |
| • Re: do i need an index for this? | J S | 14 Jul |
| • Re: do i need an index for this? | Dan Nelson | 14 Jul |
| • Re: do i need an index for this? | John Larsen | 14 Jul |
| • Re: do i need an index for this? | Dan Nelson | 14 Jul |
| • Re: do i need an index for this? | J S | 14 Jul |
