Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004

    Unanswered: preventing flyaway within query


    I have a query which updates the primary key of my table, which obviously causes flyaway - is there any way I can stop it?

    It is causing my query to be extremely slow - I think!

    My table contains blob images within a column and it may be re-indexing these also at the same time?

    Is there a way to remove keys - run the job & rebuild all indices, without losing my blob images.

    Many thanks for all advice.


  2. #2
    Join Date
    Oct 2003
    Can you give a few more details about the procedure you are using?

    One thing you might consider is to work on a copy of your table. Do a general query (i.e. Check all fields) and create a copy of the table, then perform your update on the copy. After that, ADD the copy back into the original as a update.

Posting Permissions

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