On Tue, Apr 22, 2008 at 11:41 AM, Bruno B. B. Magalhães <[EMAIL PROTECTED]> wrote: > I thing > the most problematic part of those queries are the date range part, should I > use a different index only for this column to maintain the index small?
My experience with doing data warehousing in MySQL was that when all you need is day granularity, you are much better off having a de-normalized 'days_since_epoch' column or a date dimension table with a column like that. Then your date math becomes simple integer comparisons which are much faster. - Perrin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]