Where and Case sensitivity
Posted by:
Joey JJ
Date: August 02, 2014 02:33AM
Hello,
On a basic level, I need a query like below:
SELECT WordID, Word
FROM tableWord
JOIN tempWord ON tableWord.Word = tempWord.Word
Word is stored as case sensitive, however I want to match with case insensitive.
I believe I could achieve this with;
ON UPPER(tableWord.Word) = UPPER(tempWord.Word)
But, Am I correct to assume that UPPER requires additional processing power?
And therefore is there a less-CPU intensive way to turn off case sensitivity for a single query?
This matching will actually be performed on many 1,000s of words, so any CPU savings would be great.
In addition, both tableWord.Word & tempWords.Word will actually be Indexed for speed - will that make a difference?, or even render this task impossible?
Subject
Written By
Posted
Where and Case sensitivity
August 02, 2014 02:33AM
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.