By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,643 Members | 1,057 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,643 IT Pros & Developers. It's quick & easy.

Information about a column

P: n/a
C G
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
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

Nov 23 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.