Results 1 to 3 of 3

Thread: Performance

  1. #1
    Join Date
    Oct 2002
    Posts
    4

    Thumbs up Unanswered: Performance

    I can load temp table by following ways

    1)Using Case statement in my select.
    2)Multipule updates.
    Which one will do better performance.

    Thanks
    Hari Krishna

  2. #2
    Join Date
    Oct 2002
    Location
    Hong Kong
    Posts
    5
    method 1 is a select while method 2 is a update.

    They do a same thing?

  3. #3
    Join Date
    Oct 2002
    Posts
    4

    Thumbs up

    Originally posted by frankkot
    method 1 is a select while method 2 is a update.

    They do a same thing?
    Ans: Yes.Both are used to load data into a table.Which one will do better performance?

    Thanks

Posting Permissions

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