Questions tagged [hashing]

For questions about the usage of hashing in a database context

5 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
3
votes
0answers
50 views

What is a cost of search for records in a table with an equality predicate on a non key attribute A and a static hash organization?

To speed up the search for records in a table with an equality predicate on a non key attribute A and selectivity factor fs, is preferable: A sequential organization on a key attribute ? A ...
1
vote
0answers
64 views

MySQL partitioning by hash not repeatable

I have a MySQL (5.6.17) table with a few million records that I wish to partition. In order to do this, I use this query: ALTER TABLE tablename PARTITION BY HASH(id) PARTITIONS 8; Seems to ...
1
vote
0answers
176 views

Using hashed value as quick comparison

I have a postgres table that will be used to store data pulled from several remote sources / APIs. I will be syncing the data several times a day. Since the data will vary wildly depending on the ...
1
vote
0answers
111 views

Performance of Long Primary Keys

There are plenty of discussions on the benefits and drawbacks of using hashes as primary keys, but in my case I have a database of webpages that I need to look up by address, and these addresses are ...
-1
votes
1answer
358 views

Use Sha vs md5 or Hash in Snowflake-db

Let me preface by saying that I am not using this for storing passwords or any other sensitive info -- I simply want a row-level sha/hash that I can use later or to check for unique records. My tables ...