Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2007
    Posts
    246

    Unanswered: load with statistics

    hi

    load from tabname.ixf of ixf insert into tabname statistics use profile nonrecoverable
    SQL3525N The "STATISTICS" option is incompatible with the "INSERT " option.

    i have created the profile using runstat for the table
    kindly suggest while load how i update the statistics of table
    regds
    Paul

  2. #2
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    statistics can only be collected with load/replace

Posting Permissions

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