On Tue, Mar 18, 2008 at 11:43 PM, Shelley <[EMAIL PROTECTED]> 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