oracle select查询执行时间超过SQL！ [英] oracle select query execution time is more than SQL !!!

问题描述

有人可以告诉我在Oracle和SQL中执行时间差异的原因可能是什么，因为在Oracle中它需要比Sql更多的时间。地方数据，列，键，约束都相同仍然存在差异。

请尽快回复谢谢。

can someone tell me what could be the reason for difference in execution time in Oracle and SQL, as in Oracle it takes more time than Sql. both the places data, columns, keys , constraints are same still there is difference in execution.
please reply asap thank you.

推荐答案

执行时间取决于表上定义的数据大小和索引。 Oracle和SqlServer都是高度优化的数据库引擎，它们应该在你所使用的记录号和硬件的同一联盟中运行。



如果它们不同那么你必须检查你定义的索引。

Execution time is dependent on data sizes and indexes defined on your tables. Both Oracle and SqlServer are highly optimized database engines and they should operate in the same league for your record numbers and hardware you are using.

If they are different then you must check the indexes you have defined.

这篇关于oracle select查询执行时间超过SQL！的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！