Hi,
In my application i want to get the explain plan of all the query executed and want to log that explain plan in log file. I am planning to use the hibernate or Ibatis.
Could any body help me to tell that which one support to get the explain plan of all the executed query and which one is better.
If possible please provide some reference document or code snippet to develop.
Thanks a lot
Jump to PostMaybe somebody can if you can re-word this "explain plan of all the query executed". Did you mean logging executed SQL statements?
Jump to PostSorry, never did anything similar. Only think I can recommend at the moment is to have look on Hibernate Performance documentation
Maybe somebody can if you can re-word this "explain plan of all the query executed". Did you mean logging executed SQL statements?
Thanks peter. but actually i am looking for the explain plan of all the query executed. i have no requirement of logging all the query executed but only the explain plan of all
Sorry, never did anything similar. Only think I can recommend at the moment is to have look on Hibernate Performance documentation
Are you sure you posted this thread in the correct forum?
Being both an Oracle and Java developer,
this sounds like a DB question and not a Java question.
And since this is the Java forum...
Yep, definately a DB question. I use PgAdmin on PostGreSQL and utilise it's Query Planner regulary to fine tune some of my more complex queries.
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.