Also check that the tables does not have more NULL values, which also red

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 / vaibhavi_dixit

Answer Posted / vaibhavi_dixit

Also check that the tables does not have more NULL values,
which also reduces the performance.

VD

Is This Answer Correct ?

6 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is the difference between in and between in sql?

1104

What is query syntax?

1018

What is a delimiter in sas?

1124

Why is theta join required?

1188

What is an exception in pl/sql?

1161

Is sql easier than java?

1067

How do I restart sql?

1023

What does subquery mean in sql?

1112

what's the difference between a primary key and a unique key? : Sql dba

1105

What is parallel hint?

1412

Can we rename a column in the output of sql query?

1038

How do you copy a table in sql?

1109

What jobs use sql?

1030

How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?

1203

What is a sql trace file?

1085