Which one is faster delete/truncate? Why?
- 1 Answers
- 984 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 |
Why we are using the sql language?. What is the purpose of using this?
What is compression - row-level and page-level compression?
What is the latest version of microsoft sql server?
When do you create cluster and noncluster index?
Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?
Can you leave a union at any time?
WHAT IS TRIGGERS IN SQL? AND WHAT IS THE BENIFIT?
How to return the top 5 rows from a select query in ms sql server?
Define synonym?
How can count the string ? for ex: If i have string like 'bhaskar' then i need like b:1 h:1 a:2 s:1 k:1 r:1 please give any idea on that
What are the types of database schema? : sql server analysis services, ssas
What do you mean by sql server 2005 express management tools?
-
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)
