Search Interview Questions | Click here and help us by providing the answer. Click Correct / Improve and please let us know. |
|
|||
|
| ||||
| Database - Interview Questions and Answers for 'Partitioning' - 1 question(s) found - Order By Rating | ||||
| ||||
| Ans. Creating an index creates a separate table. ... Indexes are used to speed the search of data within tables. Partitions provide segregation of the data at the hdfs level, creating sub-directories for each partition. Partitioning allows the number of files read and amount of data searched in a query to be limited | ||||