Delete and truncate command in SQL Truncate and delete in SQL
are two commands which is used to remove or delete data from
table. Though quite basic in nature both sql commands can create
lot of trouble until you are familiar with details before using
it. Truncate and delete are not just important to understand
perspective but also a very popular interview topic which in my
opinion a definite worthy topic. What makes them tricky is
amount of data. Since most of Electronic trading system stores
large amount of transactional data and some even maintain
historical data, good understanding of delete and truncate
command is required to effectively work on those environment.I
have still seen people firing delete command just to empty a
table with millions of records which eventually lock the whole
table for doing anything and take ages to complete or Simply
blew log segment or hang the machine. Most of enterprise stock
trading system maintains two kind of database one transactional
and other static. Transactional d