Hi

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


________________________________________________________________________
This e-mail has been scanned for all viruses by Star. The
service is powered by MessageLabs. For more information on a proactive
anti-virus service working around the clock, around the globe, visit:
http://www.star.net.uk
________________________________________________________________________







Yahoo! Groups Links










________________________________________________________________________
This e-mail has been scanned for all viruses by Star. The
service is powered by MessageLabs. For more information on a proactive
anti-virus service working around the clock, around the globe, visit:
http://www.star.net.uk
________________________________________________________________________