Results 1 to 4 of 4
  1. #1
    Join Date
    May 2008
    Posts
    2

    Unanswered: Tuning update query - For more than 3 billion rows

    Hi All,


    We are running one update query and the table has more than 3 billion rows and it is taking more than 6 hrs to update the full table.
    Now I want to tune the query, I have applied Index optimizer hint but when I run explain plan it is showing full table scan.

    Can any one help me how to force an Index hint in update query ?
    Also please tell me what are all the ways we have to improve the performance.

    Thanks,

  2. #2
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,520
    without the query, explain plan it's little hard to help you out.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  3. #3
    weejas is offline Grumpy old man (training)
    Join Date
    Sep 2006
    Location
    Surrey, UK
    Posts
    1,095
    Provided Answers: 17
    Quote Originally Posted by beilstwh View Post
    without the query, explain plan it's little hard to help you out.
    This.

    How many indices to you have on the table? How complicated are they?
    10% of magic is knowing something that no-one else does. The rest is misdirection.
    Beers earned: 2

  4. #4
    Join Date
    Oct 2007
    Posts
    151
    Provided Answers: 9
    page 279 should help

Posting Permissions

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