Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> counting rows

counting rows

From: <bucaliman_at_gmail.com>
Date: 30 Mar 2006 13:11:40 -0800
Message-ID: <1143753100.408985.38260@u72g2000cwu.googlegroups.com> 





Consider the tables USERS and PICTURES. When retrieving the number of
pictures from a user there are two ways:



    
  
  1.   I count them from pictures table.
  
  2.   I pick it directly from a field "numPictures" in table users.






How are you used to do this? Which is better?
Thanks
Received on Thu Mar 30 2006 - 15:11:40 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US