By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,501 Members | 1,861 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,501 IT Pros & Developers. It's quick & easy.

count(*)

P: n/a
TK
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
Jul 19 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a

"TK" <ab****************@rogers.com> wrote in message
news:ow********************@news01.bloor.is.net.ca ble.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
Jul 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.