count(*)

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • TK
    #1

    count(*)

    Can anybody think of an example where "select count(*) from..." is
    different from "select count(columnA) from...." in terms of performance?
    For example, what if columnA is indexed?

    Thanks in advance.
    -tk
    Tags: None
    • Mark C. Stock
      #2
      Re: count(*)


      "TK" <absolutely_no_ spam@rogers.com wrote in message
      news:ow4gc.1616 75$SQE.28760@ne ws01.bloor.is.n et.cable.rogers .com...
      | Can anybody think of an example where "select count(*) from..." is
      | different from "select count(columnA) from...." in terms of performance?
      | For example, what if columnA is indexed?
      |
      | Thanks in advance.
      | -tk

      google COUNT(*) -- there's been many postings on this

      ;-{ mcs


        Comment

        Previous template Next
        Working...