| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Tuning SQL
In article <3549CD74.C886842A_at_webworks.ca>, Andrew <andy_at_webworks.ca> wrote:
> snip
>
Andrew,
Following up my last reply, the index (if used) should, of course, be a comcatenated one on (postalcode,latitude,longitude).
Good luck.
--
Chrysalis
"FABRICATE DIEM PVNC"
(To to protect and to serve)
Motto of the City Guard
Terry Pratchett
Received on Tue May 05 1998 - 12:36:30 CDT
 |
 |