How do we tune the code?

Answer Posted / shobhit

we can tune our code as folllows

1:reducing no of lines in code

2: using indexes based columns in our sql select statements.

3: using the best logics

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are string functions in sql?

688


How do you run a query?

593


What is rowtype?

576


What is pessimistic concurrency control? : Transact sql

595


what is a foreign key ? : Sql dba

618






how does a local variable is defined using t-sql? : Transact sql

553


Can a commit statement be executed as part of a trigger?

611


What is a join?

637


what is user defined functions? : Sql dba

558


What is a primary key sql?

569


How many row comparison operators are used while working with a subquery?

550


Why do we use sql constraints?

668


What is a dynamic query?

583


Which is better cte or subquery?

552


What is memory optimized?

568