Subject RE: [firebird-support] splitted dates
Author Alan McDonald
> I have been using splitted dates for improving the performance in group
> bys.
> Is it a good practice?
> The only problem is that I have three extra fields and a trigger to
> maintain my data.
> ex:
> mydate date,
> myyear integer,
> mymonth integer,
> myday integer
> So in the selects I can have better use of my table information.
> Marcello

one post is enough thanks...

there's no problem splitting dates with triggers if you want to.
I use group by on non-split dates and do not experience any performance
issues. So I'm not sure what your issues here are.