![]() ![]() ![]() Transaction Wait Time specifies a period of time transactions wait for acquiring lockable resources.The Truncate Table command performs faster, requires less I/O, and journals and archives much less information than an equivalent DELETE FROM table command. This feature is useful for tables where rows require frequent deletion. ![]() Truncate Table command which allows the users and applications to empty the contents of a database table.SQL Derived Table Support (more detail later in the article).Exclusive Isolation Level which allows transactions to acquire an exclusive lock on a target table, and be the only ones able to execute SELECT, INSERT, UPDATE, and DELETE on a table. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |