This content has been marked as final. Show 117 replies
What is your Oracle Version?
Please post the output for explain plan
Oracle version is 220.127.116.11.
I don't know how to do explain plan. Can you please give me idea for doing Explain plan or else giving hints...
Query is ok, make indexes on the columns used in WHERE clause, then run the query.
I think, it might be the indexes problem,
How to define indexes in WHERE clause. Pls let me know.
I mean, create indexes on the columns used in WHERE clause ( join conditions).
Take the columns and create indexes on those columns,
i think you know, how to create indexes on those columns. if you are not dba, ask your dba will do for you
Hi Deepa ,
Am not DBA. Pl/SQL developer. We have no DBA here. So we need to solve this. So give me idea to solve this issue..
Hi here Oracle version is 9i. I know creating INDEXES(create index <name> on
<table_name(column_name)>. am i right. Then how to create index with join condition. I don't have idea oin this ...
you did not understand my words, i am not asking you to create indexes with join condition...
create indexes on the columns, the columns which are used in where clause..
I mean, list out the columns, which are used in WHERE clause,
create index INDEX_NAME on table_name( column1)
create index INDEX_NAME on table_name( column2)
I have created indexes on 6 columns . But Still I am getting the same problem.Can you pls look into this.
As i mentioned before please run explain plan so we can find the root cause
RUN THE EXPLAIN PLAN and then show us the output as well as the indexed columns.
first take statistics on those tables and run the query again
exec dbms_stats.gather_table_stats('<TABLE OWNER>,'TABLE_NAME',CASCADE=>TRUE);
if it is not helpful, send the execution plan