[HIVE-7784] Created the needed indexes on Hive.PART_COL_STATS for CBO

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.14.0
• Fix Version/s: 0.14.0
• Component/s: CBO
• Assignee: Mostafa Mokhtar
• Reporter: Mostafa Mokhtar
• Created: 19/Aug/14 17:35
• Updated: 13/Nov/14 19:43
• Resolved: 21/Aug/14 20:36

Description

With CBO we need the correct set of indexes to provide an efficient Read/Write access.
These indexes improve performance of Explain plan and Analyzed table by 60% and 300%.

MySQL 
 CREATE INDEX PART_COL_STATS_N50 ON PART_COL_STATS (DB_NAME,TABLE_NAME,COLUMN_NAME) USING BTREE;

MsSQL
CREATE INDEX PART_COL_STATS_N50 ON PART_COL_STATS (DB_NAME,TABLE_NAME,COLUMN_NAME);

Oracle 
CREATE INDEX PART_COL_STATS_N50 ON PART_COL_STATS (DB_NAME,TABLE_NAME,COLUMN_NAME);

Postgres
CREATE INDEX "PART_COL_STATS_N50" ON "PART_COL_STATS" USING btree ("DB_NAME","TABLE_NAME","COLUMN_NAME");