Subject Re: [ib-support] Optimize Query
Author Svein Erling Tysvær
Oops, sorry:
>My last suggestion may not be all too important for speed: You seem to use
>TIME fields for duration, rather than a set time (i.e. 8:15 meaning 8 hours
>and 15 minutes and not 8:15AM). Consider storing these as numbers rather
>than TIME, and simply use
> cast(sum(presenze.orelavorate)/3600) (this requires that orelavorate is

should of course be sum(presenze.orelavorate)/3600, without any casting.

And I'll try to learn from Ann's english classes about indexes for the future.