Sybase query explainer

Explain and understand query for Sybase.