Results 1 to 4 of 4
  1. #1
    Join Date
    May 2006
    Posts
    46

    Unanswered: Disabling Indexes

    Hi,

    I am working in Oracle 9i.
    Is there any way of disabling the index.
    Pl.can anyone help me on this and the impacts as well if I disable the index.

    Thanks

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Index can not be disabled; you'll have to drop it.

    > DROP INDEX index_name;

    However, you can make it unusable:

    > ALTER INDEX index_name UNUSABLE;

    To bring it back, you'll have to rebuild it:

    > ALTER INDEX index_name REBUILD;

    If you mixed terms "index" and "constraint", well, constraints can be disabled (and enabled).

    It is expected that performance will be degraded if you drop index. However, if it is about mass insert, then it is perhaps better to first drop all indexes, perform insert and, finally, create indexes because their presence might slow things down.

  3. #3
    Join Date
    Sep 2004
    Location
    London, UK
    Posts
    565
    Quote Originally Posted by Littlefoot
    However, if it is about mass insert, then it is perhaps better to first drop all indexes, perform insert and, finally, create indexes because their presence might slow things down.
    Or mark them unusable and rebuild afterwards

  4. #4
    Join Date
    May 2006
    Posts
    46

    Disabling indexes

    Hello,

    Thanks a lot for ur response

    Sathidevi

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •