Hi all, the "year" function in group by is slow.
Here is the example:
"select year(docdate), sum(docamt) FROM indexA GROUP BY year(docdate)"
is much slower than
"select docdate_year, sum(docamt) FROM indexA GROUP BY docdate_year"
Should I create another "year field", "month field", "day field" for speed?
Are there any other approach to speed the date-function in the group by clause?