This discussion is archived
2 Replies Latest reply: Jun 1, 2012 3:02 AM by DB RSS

why rebuild index needed?

DB Newbie
Currently Being Moderated
Dear All,

After Export a schema from old server and Import on new server.
*1.Need to Rebuild index?*
*2.If it is, why need to rebuild index.?*


thank you,
with Regards,
Jayaprakash.
  • 1. Re: why rebuild index needed?
    912595 Expert
    Currently Being Moderated
    DB wrote:
    Dear All,

    After Export a schema from old server and Import on new server.
    *1.Need to Rebuild index?*
    *2.If it is, why need to rebuild index.?*


    thank you,
    with Regards,
    Jayaprakash.
    If indexes are created successfully in target database then there is no need to rebuild those indexes. Import create the indexes with 'Create Index" clause and this is alomost something like a rebuild, so why you think that rebuilding indexes after they are imported if required?
    I dont see any such requirments
  • 2. Re: why rebuild index needed?
    DB Newbie
    Currently Being Moderated
    THANKS FOR ALL

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points