哪个进程是SQL Server查询最快的

时间:2021-02-14 22:32:42

I've got a question from my interviewer but I couldn't answer that. There is one row if you query for database to CREATE SELECT DELETE UPDATE which one is fastest and which one is slowest? and why? (in same condition data) He said if you know the how database system works, you ought to know.

我从面试官那里得到了一个问题,但我无法回答这个问题。如果您查询数据库CREATE SELECT DELETE UPDATE哪一个最快哪一个最慢?为什么? (在相同的条件数据中)他说如果你知道数据库系统是如何工作的,你应该知道。

1 个解决方案

#1


-1  

None of these are faster or slower in general terms. Speed depends on a great many things, not the least of which include indexing, the size of the dataset (at least for the DML options you listed -- 'create' is DDL, so not really in the same category as the others), hardware performance, and so on.

一般而言,这些都不是更快或更慢。速度取决于很多东西,其中最重要的是包括索引,数据集的大小(至少对于你列出的DML选项 - 'create'是DDL,所以不是真正与其他类别相同),硬件性能等。

#1


-1  

None of these are faster or slower in general terms. Speed depends on a great many things, not the least of which include indexing, the size of the dataset (at least for the DML options you listed -- 'create' is DDL, so not really in the same category as the others), hardware performance, and so on.

一般而言,这些都不是更快或更慢。速度取决于很多东西,其中最重要的是包括索引,数据集的大小(至少对于你列出的DML选项 - 'create'是DDL,所以不是真正与其他类别相同),硬件性能等。