Information about a column

Dear All,

I have column that contains couple of million rows of information and I was
wondering what is the standard way of keeping 'summary information' about
the column.

For instance, say each row has a number between 1 - 10 and a regular query
is "How many of the rows have numbers about 5.

I can see three ways of doing this:

1. Just query the table every time you want the information
2. Create a view for the information required
3. Create another table with a counter column, i.e. every time a number goes
in that is above 5, the counter increates by 1.

Thanks

Colin

_________________________________________________________________
Express yourself with cool new emoticons http://www.msn.co.uk/specials/myemo