How do we tune the code?
Answers were Sorted based on User's Feedback
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 |
Answer / raaaa
tuning the code is complier the output than code is verify
| Is This Answer Correct ? | 0 Yes | 4 No |
Can sql developer connect to db2?
Explain how exception handling is done in advance pl/sql?
Can we create clustered index without primary key?
How to test for null values?
oracle is compiler or interpretter,can any one tell me the answer?
Which one is better sql or oracle?
Write the sql query using dual table for below output? 1 L R --- --- ---- 1 1 1 1 2 1 1 3 1 1 1 2 1 2 2 1 3 2 1 1 3 1 2 3 1 3 3 Write a query using only Dual table with out writing any pl/sql program.
What is the difference between microsoft access and sql?
Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints
What is dense_rank?
Why is pl sql needed?
Can we perform dml in function?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)