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 a constraint?

1085

Is natural join and inner join same?

994

What is sql and how does it work?

1252

How is a process of pl/sql compiled?

1243

Is grant a ddl statement?

945

What are %type and %rowtype for?

1109

Explain what is a column in a table?

1161

What is mutating table error?

1240

how to convert dates to character strings? : Sql dba

1253

Who is the owner of mysql database?

1108

Is oracle and sql same?

1078

What is denormalization in a database?

1107

What are some emotional triggers?

1036

What is write ahead logging in sql server?

1101

how many sql dml commands are supported by 'mysql'? : Sql dba

1169