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