A server side trace using TSQL tuning template produces that 3 stored procedures are used during those reports execution, a SHOWPLAN event activity reveals that there are multiple scan operations such as index scan, hash-join, index seek and table scan on the above 3 tables. Your job is to provide a descriptive answer about each of the above operation (hah-join/scan/seek) and feedback which operation will be fastest (why) and will be slowest (why) with valid reasons.