Orlando Andico wrote:

> On Thu, 19 Oct 2000, Rafael R. Sevilla wrote:
> ..
> Ok, here's a fairly simple example from my recent experience: how do you
> efficiently index a large field in a SQL database so that you can do
> nearness searches on it? the standard SQL "LIKE" clause is no good,
> because it forces full-table scans and in any case cannot return ranking
> results.

this is easy for oracle if i recall it correctly because this one of its strong
point. but in other sql, if you know the algorithm behind what oracle use then i
believe you can easily solve your problem.

fooler.



_
Philippine Linux Users Group. Web site and archives at http://plug.linux.org.ph
To leave: send "unsubscribe" in the body to [EMAIL PROTECTED]

Reply via email to