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

Is and as keyword in pl sql?

899

Why plvtab is considered as the easiest way to access the pl/sql table?

1129

what is bcp? When does it used? : Sql dba

932

Why do we go for stored procedures?

993

How do I create a memory optimized filegroup?

903

What is the use of %rowtype?

975

what is the difference between sql and t-sql? : Transact sql

1040

Which language is used in sql?

986

what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba

942

Is sql similar to python?

916

Explain the select statement in sql?

1043

What is procedure explain with program?

949

What are the various levels of constraints?

1058

How to run pl/sql statements in sql*plus?

1020

What are the two types of cursors in pl sql?

1001