Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004
    Location
    Dublin, Ireland
    Posts
    212

    Unanswered: can someone explain?

    Hi guys, what's up?
    can someone explain to me, what's the diffrence between
    SELECT...;
    and
    SELECT... FOR UPDATE; ?

    My 2nd question is:
    Does someone know about very good manual or tutorial (on the web) where can I find something about EXPLAIN PLAN and about optimization queries by EXPLAIN PLAN...

    thanx a lot

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: can someone explain?

    1) SELECT alone does not lock the records selected; SELECT ... FOR UPDATE does.

    2) Have you tried the Database Performance Tuning Guide and Reference ?

  3. #3
    Join Date
    Jan 2004
    Location
    India
    Posts
    191
    Can also go through the below URL
    http://www.dbspecialists.com/present...e_explain.html
    Pagnint
    (No need to search web before posting new question)

Posting Permissions

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