home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.databases.oracle      Overblown overpriced overengineered SHIT      2,288 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 1,301 of 2,288   
   .com to All   
   Re: count(*)   
   17 Apr 04 08:38:07   
   
   From: mcstockX@Xenquery   
      
   "TK"  wrote in message   
   news:ow4gc.161675$SQE.28760@news01.bloor.is.net.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   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca