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 |
Authentication mechanisms in Sql Server ?
Does access use sql?
What is trigger in pl sql with examples?
i have a table emp and columns ename,empno,mgr_id,i need ename,manager name as result i.e employee respective manager.. example empno ename mgr_id 1 john 3 2 paul 3 3 smith 1 4 kevin 1 5 stewart 2 result has to look like this ename manager john smith paul smith smith john kevin john stewart paul can u plz help me out in this.....
how will be date change into string
What are the types of dbms?
Where do we use pl sql?
Query for second maximum salary in each in each department
15 Answers DST Global Solutions, TCS,
What is trigger in sql? Explain
what is auto increment? : Sql dba
Is there any problem if we use commit repeatedly after each dml statement in a plsq procedure ? (eg. there are 10 update stmt and using 10 commit stmt after each update stmt)
How many parts of a pl sql block are optional?
Oracle (3259)
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)