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.

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a temporal data type?

599


What is recursive join in sql?

556


What is delimiter sql?

554


What is memory optimized?

566


what are the advantages a stored procedure? : Sql dba

555






How to run sql*plus commands in sql developer?

596


What is data definition language?

630


What is the execution plan in sql?

568


How much ram can sql express use?

517


Does sql use python?

574


What operators deal with null?

617


What are transaction and its controls?

569


What is an index in sql with example?

523


What does data normalization mean?

547


What is difference between ms sql and mysql?

484