How do we tune the code?
- 2 Answers
- 4945 Views
- I also Faced
- E-Mail Answers
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 |
Why we use cross join?
How many types of indexes are there in sql?
Is it possible to use Transaction control Statements such a ROLLBACK or COMMIT in Database Trigger ? Why ?
what is offset-fetch filter in tsql? : Transact sql
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?
Why do we need pl sql?
how can we destroy the cookie? : Sql dba
Why do we use triggers?
Explain ttitle and btitle.
What is t sql in sql server?
What is a primary key example?
Why do we use sql constraints? Which constraints we can use while creating database in sql?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
