count question

Results 1 to 2 of 2

Thread: count question

  1. #1
    Join Date
    Dec 1969

    Default count question

    is there a performance benefit of using one against <BR>the other here ? <BR><BR>select count(*) from table_name <BR>select count( primary_key_field ) from table_name <BR><BR>OR they are essentially exactly IDENTICAL ?

  2. #2
    Join Date
    Dec 1969

    Default Yes

    * has to be sent to find the field names (all of them) then do a count.<BR>Using a field name eleviates this find field names!

Posting Permissions

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