How do we tune the code?
- 2 Answers
- 5312 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 |
tell us something about heap tables. : Sql dba
How is sql used in oracle?
What is nvarchar in sql?
Which query operators in sql is used for pattern matching?
How are multiple column = value pairs delimited in the SET clause of an UPDATE statement? 1. With commas (SET price = 0, status = 'I') 2. With parentheses (SET (price = 0) (status = 'I')) 3. With double-pipes (SET price = 0 || status = 'I') 4. With square-brackets (SET [price = 0] [status = 'I'] 5. With single or multiple spaces (SET price = 0 status = 'I')
Explian rowid, rownum?
What is the use of partition by in sql?
What is a 'instead of trigger'?
Is foreign key mandatory?
How to convert comma separated string to array in pl/sql?
Can you selectively load only those records that you need? : aql loader
Why do we need sharding?
-
Oracle (3258) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3328)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
