CODEWITHSUNDEEP
javamysqlhibernatesql-execution-plan
user3244167
user3244167

Reputation: 31

How can i check the query execution plan?

In the Java application we are developing when loading a page time out exceptions are been thrown. So i am assigned to investigate the issue. there are several database fetches that are happening when loading the page. So i want check which queries are running parallel and the execution plan. Whether there are any unnecessary joints and indexes. The data base is mysql and have used hibernate in the back-end.

So can anyone left me know how i can get the execution plan and check what queries are being executed parallel.

Upvotes: 1

Views: 1394

Answers (1)

hide
hide

Reputation: 92

You can define in your hibernate properties this.

            hibernate.format_sql=true
            hibernate.show_sql=true
            hibernate.dialect=org.hibernate.dialect.MySQLDialect

Upvotes: 1

Related Questions