Quote:
Originally Posted by MarillionFan
Shame, DimPrawn is poo pooing that idea above, shows he only has limited experience 
Yes it's an Oracle 10 Database.
There appears to be some Oracle functionality that does seem to create an index of all combinations(as suggested above) based around 'Oracle Text'. From reading the article, it can also be designed to use a fuzzy logic match.
The only problem appears to be if the index is greater than the actual original column, but then again an index using an equal would be quicker than a wildcard anyway
Is this a good method?
http://209.85.173.104/search?q=cache...lnk&cd=1&gl=uk |
No, you carry on mate. Be interesting to see you create your own "google" style index on 55M rows rather than use a highly optimised and sophisticated tool designed for the job such as Full-Text Index on SQL Server.
__________________
By the time you finish reading this sentence, the national debt will have risen by another £1,500 - which you or your children will have to repay.
Just so you know.
|