Update Index / Rebuild Index ALTER INDEX index_name ON table_name [partitionSpec] REBUILD; EXAMPLE : ALTER INDEX src_index ON src REBUILD; ALTER INDEX src_part_index ON srcpart_rc REBUILD; ALTER INDEX src_part_index ON srcpart_rc partition(ds='2010-08-09') REBUILD;
{}