How do we tune the code?

Answers were Sorted based on User's Feedback



How do we tune the code?..

Answer / 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

How do we tune the code?..

Answer / raaaa

tuning the code is complier the output than code is verify

Is This Answer Correct ?    0 Yes 4 No

Post New Answer

More SQL PLSQL Interview Questions

How to get each name only once from an employee table?

0 Answers  


Why do we use subquery?

0 Answers  


explain normalization concept? : Sql dba

0 Answers  


How to update salary of employees department wise?

6 Answers  


What are tables and fields in the database?

0 Answers  






What is time based sql injection?

0 Answers  


in sql table following column r there i want find 1st paid ,2nd paid,3rd paid date for same |service_type|date |vehicle_no| |------------|------|_---------| |paid |23 jan|MH12H2007 | | | | | |paid |26 feb|MH12H2007 | | | | | | | | | |paid |28 mar|MH12H2007 | i want o/p like below vehicle no| 1st paid date | 2nd paid date|3rd paid |latest paid date| pls help me out

4 Answers  


how do you restrict number of rows for a particular value in a column.For example:there is a table called fruits,having apples,bananas ,papayas.I dont want to have more than 100 apples in that table ,so how can u restrict number of rows for apple to hundred?

6 Answers  


Suppose There is a string A.B....C.......D.........E........F In this string dots (.) are not having fixed count in between of string. I want the output to have string with one dot between. I.e. A.B.C.D.E.F

6 Answers   IBM,


what is msql? : Sql dba

0 Answers  


how to use myisamchk to check or repair myisam tables? : Sql dba

0 Answers  


Can you join views in sql?

0 Answers  


Categories