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 is trigger types in sql?

725


Is it possible to update views?

714


What is the usage of nvl function?

773


What is a ddl command?

722


Can two tables have same primary key?

731






Can a view be mutating? If yes, then how?

753


How to avoid using cursors?

769


Describe sql comments?

731


how can we destroy the session, how can we unset the variable of a session? : Sql dba

731


How can we optimize a sql query?

766


how to get @@error and @@rowcount at the same time? : Sql dba

745


What are the most important characteristics of pl/sql?

785


Where is sql database stored?

689


How many parts of a pl sql block are optional?

718


How many postgresql users are there, worldwide?

780