I would try books online and Google, but unless your queries are super complicated, just try and stay away from table scans on large tables. Very bad. If you see a table scan on a large tables, try applying an index on that field unless there are a lot of inserts up dates and deletes in which case the speed you gain in reporting will be lost in transaction. There are lots of things to consider... I hate databases.