Re: count(*)

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