Search Interview Questions
| More than 3000 questions in repository.|
There are more than 900 unanswered questions.
Click here and help us by providing the answer.
Have a video suggestion.
Click Correct / Improve and please let us know.
|Database - Interview Questions and Answers for 'Indexing' - 1 question(s) found - Order By Newest|
|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|
|Help us improve. Please let us know the company, where you were asked this question :|
|Like Discuss Correct / Improve  indexing  partitioning Asked in 3 Companies|