trace SQL

Hi.

How can I get some information of the execution plan of a SQL statement?

I want to check if and how my queries take advantage of indexes, keys, etc...

thank you

-- 
* * * * *  Michelos * * * * * * 
 http://spark.net.gr/~michelos
  email:michelos_at_spark.net.gr
* * * * * * * * * * * * * * * *