为报告目的索引数据库查询

I have a database that stores data for all parts that are produced on a assembly line, there where about 1 million parts produced, each one with lets say 200 entries. The customer wants me to do several queries to get some informations about how production is going.I have a database that stores data for all part