All Questions
6
questions
0
votes
1
answer
74
views
Adding Indexes to improve performance
I have a query which is taking around 4 hrs to execute. I need to add indexes to improve the performance. Please suggest where I can add the indexes for the explain plan below: Also please suggest ...
0
votes
1
answer
109
views
Understanding the Explain plan
I have a query that is taking 10 secs of time to run currently(about 300 lines). Now I add a where condition table_a.column_a ='XXX' like in the below query. The amount of time it takes to run it now ...
2
votes
1
answer
1k
views
Explain plan and Query execution time differences
I have two tables TABLE_A and TABLE_B ( one to many. FK of table_a in table_b ). I have written the following 3 queries and each one of it will perform at different speeds on the tables but basically ...
0
votes
2
answers
993
views
Invalid sql statement for "Explain plan for with" statement
I am executing the following query:
explain plan for
with Foo
as (
select * from my_table
)
select * from Foo
where x = 7;
This results in an invalid SQL statement exception in ...
2
votes
4
answers
322
views
Oracle SQL query - unexpected query plan
I have a very simple query that's giving me unexpected results. Hints on where to troubleshoot it would be welcome.
Simplified, the query is:
SELECT Obs.obsDate,
Obs.obsValue,
...
4
votes
4
answers
6k
views
How accurate is Oracle's EXPLAIN PLAN?
Are there any good ways to objectively measure a query's performance in Oracle 10g? There's one particular query that I've been tuning for a few days. I've gotten a version that seems to be running ...