Joined: 23 Nov 2006 Posts: 19270 Location: Inside the Matrix
is there any manual for it?
Not that i'm aware of.
Tuning a query is much like tuning anything else. Determnine where the resources are being used and reduce this where possible. Sometimes this requires a complete redesign of the query or process as well as database modifications.
Suggest you talk with your dba to learn what is available for you to use to research. There is always EXPLAIN.