Index problem (urgent)
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Index problem (urgent)

  1. #1
    Join Date
    May 2001
    Location
    India
    Posts
    55
    Hi,

    When I deleting records, It will take nearly one hours and recreating index will take more than 8hours.

    The table 'ORDER' size is 1.2GB

    What is the problem for recreating Index?

    Maile me ,

    my email id is shankar_gk@hotmail.com

    G.Shankar.

  2. #2
    Join Date
    Jan 2001
    Posts
    2,828

    Talking

    Hello

    Why recreate the index if you are on 8i try rebuliding the index instead..............as index revuilding is much faster .

    regards
    hrishy

  3. #3
    Join Date
    Feb 2001
    Location
    Bombay,India
    Posts
    530
    Hi,
    Its better to rebuild the current index rather than dropping and recreating it.In Oracle 8i there is an option of rebuilding the index online when u are performing DML statements on the table.
    So its better to rebuild the index in the less office peak times(usally in the night) which will be faster.
    Command to rebuild the index online

    alter index scott.empno_index rebuild online;

    Regards,
    ROhit Nirkhe,Oracle DBA,OCp 8i
    rohitsn@altavista.com

Posting Permissions

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



Click Here to Expand Forum to Full Width