float matching with 'like'
Hi,
I've a table about 10 million records and want to search for one matching float. It doesn't match any if I use '=', but its ok with 'like'. But then it takes about 30 sec to find one match, and I have about 500 000 requests, so it would take half a year :-(( ...
Has somebody alternative ideas?
Subject
Written By
Posted
float matching with 'like'
November 17, 2006 08:19AM
November 18, 2006 01:21PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.