Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Converting Strings to ASCII codes to increase search performance

Converting Strings to ASCII codes to increase search performance

From: spacedog <s1m0nc00k_at_hotmail.com>
Date: 19 Feb 2007 03:53:44 -0800
Message-ID: <1171886024.757774.157790@m58g2000cwm.googlegroups.com>


Hi,
We have a system that contains 50M customer records. We need to repeatedly search this table to see if the new customer is actually a new customer or has been a customer of ours in the past. Some of the development guys have come up with the idea of converting some of the fields to their ASCII code representation as they think this will be quicker that doing straight string comparisons. I have been trying to do some research around this and can't find anything that supports this.
Has anyone come across this in the past or have any ideas.

Thanks
Simon Received on Mon Feb 19 2007 - 05:53:44 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US