Which one is faster delete/truncate? Why?
- 1 Answers
- 980 Views
- Infosys, I also Faced
- E-Mail Answers
Answer / pankaj dhatrak
Truncate is more faster
reason truncate direct drop the data page and not save the transactions.
| Is This Answer Correct ? | 0 Yes | 0 No |
which database is best to use in oracle and sql server? explain reasons?
Can you explain what is sql server english query?
List all the types of user-defined functions?
How to retrieve error messages using odbc_errormsg()?
How many types of triggers in sql server?
What is left outer join in sql server joins?
What is the osql utility?
What command do we use to rename a database?
How network traffic be reduced by using the stored procedure?
can i write function in stored procedure and stored procedure in function and nested procedure.Give one example for each question?
What is difference in performance between insert top (n) into table and using top with insert?
Explain the third normal form(3nf)?
-
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)
