>> What is the step by step procedure for tuning a large sql query. <<

What is the Good Life and how can I lead it, Socrates? Ghod, you work
for the iignorant.

Steps? There are only guidelines:
1) Have a normalized design, so the data has integrity.
2) The queries are a few magnitude of orders easily with 5NF
3) Trust thr optimizer, Luke