Should I use one or two tables for summary data?

From: Victor Porton <porton_at_narod.ru>
Date: Mon, 06 Feb 2017 17:51:43 +0200
Message-ID: <o7a62o$6c3$1_at_gioia.aioe.org>



[Quoted] Please advise:

[Quoted] I need to store data grouped by days and by producers and also summary data, that is the result of SUM() (for all producers) grouped by days.

Should I make two tables (one for producers data and one for summary one) or one table with `ProducerID IS NULL` indicating the summary data (sum for all producers)?

Don't advise not to store the summary data and use SUM() instead, because I want it to be fast in retrieval.

[Quoted] The data is also grouped by other fields.

-- 
Victor Porton - http://portonvictor.org
Received on Mon Feb 06 2017 - 16:51:43 CET

Original text of this message