Hello,
we have a big table (about 5 mio entries an it will grow fast) for which we have to generate some statistic selects.
The SELECT has 6 different groupings which are not part of the where statement.
If I create an index only over the where fields the costs are very high. I think because the database has to load all relevant table records to perform grouping.
If I create the index also over the group-fields the costs are much more smaler, because the database can use the index for grouping.
But in this case the index will bew very big and we ran into memory problems.
Are there any other strategies for handling such case?
I do not need every group field in every query. But to make an index for WHERE/GROUP combination is overkill.
regards,
Michael
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
