Databases

Drop partitions without affect the status of the indexes   To drop partitions without affect the index status, use below query. ALTER   TABLE   <tableName>   DROP   PARTITION <partitionName>   UPDATE   GLOBAL   INDEXES;