June 17th, 2009

Data Definition Language, DROP INDEX

Posted by admin in Q. Data Definition Language

DB2, Oracle, PostgreSQL Format:

          DROP INDEX index_name;

Access, MySQL Format:

          DROP INDEX index_name
            ON table_name;

SQL Server Format:

          DROP INDEX table_name.index_name;

Because an index is completely separate from its associated table, it can be deleted at any time without any effect on the base table other than performance issues. All SQL code will continue to function normally.

Most RDBMS systems have tools for measuring performance. If a table is small, or the data is infrequently referenced, you may choose to remove the index.

The SQL standard does not mention indices so vendors do their own implementation.

2 Responses to ' Data Definition Language, DROP INDEX '

Subscribe to comments with RSS or TrackBack to ' Data Definition Language, DROP INDEX '.

  1. How I Make $300 a Day Online said,
    on June 17th, 2009 at 6:24 pm

    Hey, nice post, really well written. You should post more about this.

  2. Edi Software said,
    on February 6th, 2010 at 8:29 am

    Very good post I love your site keep up the great articles

Leave a reply

:mrgreen: :neutral: :twisted: :shock: :smile: :???: :cool: :evil: :grin: :oops: :razz: :roll: :wink: :cry: :eek: :lol: :mad: :sad: