All Questions
5
questions
3
votes
2
answers
512
views
How do I get a PostgreSQL execution plan with parameters?
My application has a myriad of queries and I wanted to get the execution plan of some of them. Most if not
all of the queries have multiple parameters and I can't find how to get the execution plan ...
1
vote
0
answers
216
views
Displaying Query and its Explain Plan as a HashMap
I have to generate execution plans for each query extracted from a log file. I have to generate a Hashmap that contains the query as the key and value as the execution plan. This HashMap is to be ...
2
votes
1
answer
49
views
How can I return Execution plans of a set of SQL queries located in a txt file, using Java?
I need to retrieve some information, sequentially, from the execution plans of a set of SQL queries stored in txt file. I have more than 2000 SQL queries so I need a program to do this.
I've tried ...
1
vote
1
answer
3k
views
Hibernate criteria takes too long in web app but it is fast in SQLPlus?
In web-app hibernate criteria taking too long against oracle db. I enable the log4j.logger.org.hibernate.SQL=debug SQL and run the sql query with same bind variable in sql plus the result is instance. ...
3
votes
1
answer
1k
views
Java Parsing Oracle Explain Plan
I wonder if there is any library that allows for parsing oracle's explain plan into a data structure.
Given the following query:
select prod_category, avg(amount_sold)
from sales s, products p
...