Question

Why hash-based indexing is not suitable for range queries?

Why hash-based indexing is not suitable for range queries?

Engineering   Computer-Science   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1

Hashing is a technique used to locate a single data record in a fast and effecient manner. Since it is used for the mentioned purpose, range queries will not fit into its scope.

The Range queries are finding the matching data within a lower limit and an upper limit. For example, finding all the numbers in a database table column between 10 and 20. This will fetch all the numbers between 10 and 20 available in the specified column. Here the requirement is not to fetch a data record directly and also the number of results retrieved will vary.

So hashing is not suitable or will not be effecient for range queries.

0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
The benefits of a B+ Tree compared hash-based indexing
The benefits of a B+ Tree compared hash-based indexing
2. Based on the pI of OleT, estimate a suitable pH range for buffers to be...
2. Based on the pI of OleT, estimate a suitable pH range for buffers to be used for purification of OleT via anion exchange chromatography. (1 pt)
(a). Briefly describe why an investor might consider enhanced indexing, rather than pure indexing. (b). Briefly...
(a). Briefly describe why an investor might consider enhanced indexing, rather than pure indexing. (b). Briefly describe some of the limitations to cash flow matching as an investment strategy.
how i solve this question? Select the right answer: Based on MD5 hash algorithm if the...
how i solve this question? Select the right answer: Based on MD5 hash algorithm if the message length is 512 KB, then the hash value (output) could be haw many bytes:    128 bytes 481 bits 512 bits 16 bytes None of the above
how i solve this quistion ? Based on MD5 hash algorithm, M1 required 10 blocks and...
how i solve this quistion ? Based on MD5 hash algorithm, M1 required 10 blocks and padding size is 8 bits. M2 required 3 blocks and padding size is 480 bits. If M1 and M2 are combined in a single file called M3. Find M3 size
Why is delta modulation not suitable for very low frequency signals?
Why is delta modulation not suitable for very low frequency signals?
Is the waterfall approach suitable for a realization-type problem? If so, why?
Is the waterfall approach suitable for a realization-type problem? If so, why?
Why it is not suitable to use ROA and ROE to measure the performances of financial...
Why it is not suitable to use ROA and ROE to measure the performances of financial institutions?
Would steel or aluminum be more suitable for a liquid oxygen container? Why?
Would steel or aluminum be more suitable for a liquid oxygen container? Why?
Write the following SQL queries based on hbsoe database from Mode: Select all the employee information...
Write the following SQL queries based on hbsoe database from Mode: Select all the employee information and list them for first 100 only. Select all the order information from country Germany. How many distinct orders are made from each country? List the names of employees who made orders from country Germany. List the names of companies which supplies chai or tofu
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT