> > Generate some test data and test it's behaviour yourself.
>
> I no need generate more, I have loads of date, but trying never can
> see they use great optimized, for only 3 years, always reading
> thousands of record to look for MAX ...
>
> In the case I exposed, what is the recomanded Indexes or Constraints?

Well, given that there is a logical difference between the two,
choose what fits your requirements.

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com