Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2002
    Location
    Shanghai , China
    Posts
    63

    Unanswered: Why select count(*) is faster than select count(1)?

    Why select count(*) is faster than select count(1)?

    I thought count(*) will take longer as oracle need to find out all the column names from dictionary ...
    Oracle is an ocean . I am just a little fish

  2. #2
    Join Date
    Aug 2002
    Location
    Belgium
    Posts
    534
    With count(*) he doesn't have to validate column names. Parsing is much faster.
    rws

Posting Permissions

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