On Tue, Mar 18, 2008 at 11:47 PM, Nathan Nobbe <quickshiftin@xxxxxxxxx> wrote: > On Tue, Mar 18, 2008 at 11:43 PM, Shelley <myphplist@xxxxxxxxx> wrote: > > > Hi all, > > > > What do you think is the FASTEST sql to get the total number of a table > > with millions of records? > > > when you say 'total number' do you mean the total number of records? in > that case assuming the table has a field 'id' then i think > select count(id) from some_table; > > -nathan That works; I'm just wondering why you went with a count on an 'ID' column rather than COUNT(*). Andrew
