The best replacement for delete is truncate.

Лучшие альтернативы к delete можно упорядочить следующим образом:
★★★★★  truncate
★★★★  delete
★★  truncate oracle
★★  free
★★  deactivate facebook
★★  truncate sql
★  remove
★  pad vob
★  backspace
★  destroy
★  quarantine
★  backspace mac
★  archive facebook messages
★  format
★  truncate table
★  archive gmail
★  uninstall
  unmount datastore
  move to chest
  consolidate snapshots
  delete c++
  truncate sql server
  erase
  truncate in sql
  drop
  drop table
  egr cooler
  truncate in oracle
  truncate which is faster
  trunc
  quarantine viruses
  archive
  quarantine virus
  dealloc
  meet
  purge
  free c++
  rewrite heretics
  format partition
  delete subfolders and files
  reformat
  delete from

Ваша альтернатива к delete не упомянута? Предложите!
Говоря о delete, пожалуй, не стоит забывать о inner join.

Другие запросы относящиеся к delete можно упорядочить так:
★★★★★ inner join
★★★ rollback
★★ rowlock
★ new
★ trash
★ programmer
★ tuner
★ smarty
nologging
Вам известен компаньон к delete и он пока не упомянут тут? Предлагайте!



Google Trends

Scale is based on the average worldwide traffic of delete in all years. Click on graph for more.
delete
truncate
delete