Re: Table with Text values
Posted by: Gilad Granit
Date: December 17, 2015 03:53AM

The hash cannot be unique due to the collusion option..
but the index on ('hash', 'text') can be unqiue and the select will use where 'hash'='123' and 'text'='text'

this sounds like a good solution?

right now i set the text size to 128, but i couldn't understand why i don't need the "hash trick" on this case.

Options: ReplyQuote


Subject
Written By
Posted
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
Re: Table with Text values
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.