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