MySQL和Oracle DB之间的区别 [英] Differences between MySQL and Oracle DB

问题描述

MySQL和Oracle 11g之间在功能和性能上有什么区别?我希望能够根据情况在两者之间做出明智的选择.

What are the differences - features and performance - between MySQL and Oracle 11g? I would like to be able to make and educated choice between the two given a situation.

注意:显然，指向测试的链接会有所帮助.

Note: Links to test will obviously help.

推荐答案

MySQL仍然缺乏(Oracle拥有)

Things that MySQL is still lacking (that Oracle has)

• 可延迟约束
• 检查约束
• 递归查询
• 表函数
• 常用表表达式
• 窗口功能
• 基于功能的索引
• 部分索引
• 没有减号(或INTERSECT)运算符
• 关于子选择的非常简单的查询优化器
• 很多非标准语法(||是逻辑或！)
• 不闪回

• deferrable constraints
• check constraints
• recursive queries
• table functions
• common table expressions
• windowing functions
• function based index
• partial index
• No MINUS (or INTERSECT) operator
• very simple query optimizer when it comes to sub-selects
• A lot of non-standard Syntax (|| is a logical or!)
• no flashback

这篇关于MySQL和Oracle DB之间的区别的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！