Hi
We have a very large table of patient visits to Hospitals (40 million records) covering 2005 through 2008. In order to improve on how long it takes the reports to run through all this data, we are thinking of segmenting the data into four separate tables (one for each year), since we generally look at data for one year at a time.
If we do this, is there any way of selecting the table "on the fly" so to speak, based on the date range and have corresponding record selection statements? We would like to have to avoid re-writing the report every time we need to run it for a different year.
The tabels will eb called
2005_visits
2006_visits
2007_visits
2--8_visits
Thanks in advance.
Jay
We have a very large table of patient visits to Hospitals (40 million records) covering 2005 through 2008. In order to improve on how long it takes the reports to run through all this data, we are thinking of segmenting the data into four separate tables (one for each year), since we generally look at data for one year at a time.
If we do this, is there any way of selecting the table "on the fly" so to speak, based on the date range and have corresponding record selection statements? We would like to have to avoid re-writing the report every time we need to run it for a different year.
The tabels will eb called
2005_visits
2006_visits
2007_visits
2--8_visits
Thanks in advance.
Jay