DROP INDEX Syntax

11 February 2012 By Nithya Vasudevan 143 views No Comment
0 Flares Twitter 0 Facebook 0 Google+ 0 0 Flares ×

DROP INDEX index_name ON tbl_name

DROP INDEX drops the index named index_name from the table tbl_name.

After deleting the index on ‘gender’ column, the performance enhancement is lost.

Tags: , ,