Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003
    Posts
    9

    Unanswered: Update Statistics

    Hi,
    I have a number of tables where I am facing the problem of slow
    INSERT speed due the INDEXES.

    How can I improve the insert speed on tables with INDEXES?
    I know UPDATE STATISTICS improves the query performance.
    But how to I improve the performance of data INSERT.

    many thanks in advance.

    Best Regards
    Madan

  2. #2
    Join Date
    Feb 2002
    Location
    Willy is on vacation
    Posts
    1,208

    Re: Update Statistics

    I guess, it is much quicker then to drop those indexes at choose fast bcp instead.

    Re-create the indexes once bcp is done.

Posting Permissions

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