check the how many indexes created on join column of tables, check the jo

What is the first action to perform a query?
Suppose I have four tables and five joins and my query is
getting slow day by day.

Question Posted / avi007

Answer Posted / avi007

check the how many indexes created on join column of
tables, check the join which has been done on common column
of both tables.

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to fetch values from testtable1 that are not in testtable2 without using not keyword?

1227

How do you define a foreign key?

1010

What is over () in sql?

969

What packages(if any) has oracle provided for use by developers?

5811

What is cost in sql execution plan?

990

what are date and time intervals? : Sql dba

1062

What is clustered index in sql?

1056

What are the different tcl commands in sql?

1182

What is an ndf file?

997

How can we make an if statement within a select statement?

1017

Are subqueries faster than joins?

1024

How to combine two stored procedures in sql?

1241

What is a sql driver?

1004

What is range partitioning?

973

Can a procedure in a package be overloaded?

1047