2 Replies Latest reply: Jun 1, 2012 5:02 AM by DB RSS

    why rebuild index needed?

    DB
      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
          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
            THANKS FOR ALL