Re: Need a Fast Row Count

How much faster is your count if you use select count(1) from... ?
In this case only the first column of every row will be read, not the whole row!

This might not be as quick as some of the other ideas, but I would be interested in the statistics.
Unfortunately none of my tables is big enough to really make a difference!

Simone Received on Mon Mar 27 2000 - 00:00:00 CST