RE: count(*)

True but at least 'where 1=1' doesn't use a lock Paul Watson # WF Software Ltd # You are only young Tel: +44 1463 674729 # once but you can be Fax: +44 1463 678729 # immature forever www.wfsoftware.com # > -----Original Message----- > > M00n321 wrote: > > > > >Is more fast count(*) or count(table.column) ? > > > > With count it depends on how accurate you want your result. Count > without any > > restrictive clauses will draw its result from the table > statistics, not > > necessarily correct. To ensure an accurate count one must > force a look > at the > > data. WHERE 1=1 works nicely. > > I disagree. There is not necessity to use where clause to force > engine to return real number of rows. > > Vardan Aroustamian > > -- > vaar@geocities.com > > >