Anybody wants to share some useful information for a beginner,

I've been informed that Indexes is a method which could be used to improve performance, one way to measure performance is by length of time,

Can anyone suggest two performance critical transaction methods which involve

a) joins of atleast 3 tables
b) recursion

Own tables could be used but if in doubt please feel free to ask for additional information.

Thanks in Advance to all.