Table with Text values
Posted by: Gilad Granit
Date: December 13, 2015 09:28AM

Hey,

i'm thinking on the best way to build a table with lots of text data on it that will be searchable with "euqal" sign.. no like or nothing like that.
(it just need to contain unique text values without duplicates.)

text will probably not be longer than 100 characters so i thought about limiting it with varchar(255) but for the search i thought about adding another field with the hash of the text with index on it.. is it necessary ?

if so how will a query with "Select * from table where hash=123 and text ='text' "
perform ?


thanks in advance for any help.

Options: ReplyQuote


Subject
Written By
Posted
Table with Text values
December 13, 2015 09:28AM
December 13, 2015 10:44AM
December 14, 2015 01:05AM
December 14, 2015 08:02AM
December 16, 2015 10:25PM
December 16, 2015 10:27PM
December 17, 2015 03:53AM
December 17, 2015 01:00PM
December 17, 2015 03:52PM
December 18, 2015 05:34PM


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.