3 Replies Latest reply: Jan 11, 2013 2:57 AM by Karthick_Arp RSS

    Gather Statistics & Index Rebuild..

      Hi All,

      Am having the table which will have get the data's from excel file or csv about 3000K records. From the table I will insert to application table based several condition's using java in front end.

      From database aspect at initial stage I hope this table wouldn't have any table statistics,index statistics.

      I need kindly suggestion from you people

      1. which one will be the best
      a. create index on column and import the data on table and rebuilt the index
      b. import the data and create the index for column

      2.whether i have to collect the statistics before running the process.?

      Thanks & Regards

      Edited by: Sami on Jan 11, 2013 12:03 PM