How can I check a query execution?

[SuvenduSekhar Panda]

Hi,

I am Suvendu. I am working on a project where I came across on a sql query. I want see the execution flow fully. i.e how the query executed on database. what can I do for this?

can any body help me for this?


Regards

Suvendu

[Peter Johnson]

Most database will tell you information about the execution of an sql query. But that is a database capability, most often provided via the database management UI. I don't know of any Eclipse plugin that would grab this kind of information from the database for you.

What database are you using?

[SuvenduSekhar Panda]

I am using ORACLE 10g express edition

[Peter Johnson]

This should help: http://docs.oracle.com/cd/B10500_01/server.920/a96533/ex_plan.htm