最新活动:电脑PC端+手机端+微网站+自适应网页多模板选择-建站388元起价!!!
当前位置:主页 > 网站建设 > where条件顺序不同、性能不同示例探讨建站知识

where条件顺序不同、性能不同示例探讨建站知识

时间:2023-05-24 11:05:24 阅读: 文章分类: 网站建设 作者: 建站小能手

导读:1建站知识where条件顺序不同,性能不同,这个建议在Oracle11G版本还合适吗,想提高性能的的朋友可以参考下哈网站优化seo培训公司网站建设。

网站优化seo培训公司网站建设昨天在书上看到SQL语句优化时,where条件顺序不同,性能不同,这个建议在Oracle11G版本还合适吗?方式1优于方式2? 方式1:

复制代码 代码如下:

select a.* from students s, class c where s.id = c.id s.id = 'xxxxxxxx'

方式2:

复制代码 代码如下:

select a.* from students s, class c where s.id = 'xxxxxxxx' s.id = c.id

10g中测试结果证明是一样的。 Microsoft Windows [版本 5.2.3790] (C) 版权所有 1985-2003 Microsoft Corp. C:\Documents and Settings\Administrator>sqlplus / as sysdba SQL*Plus: Release 10.2.0.1.0 - Production on 星期六 5月 11 17:48:55 2013 Copyright (c) 1982, 2005, Oracle. All rights reserved. 连接到: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production With the Partitioning, OLAP and Data Mining options SQL> alter system flush shared_pool; 系统已更改。 SQL> alter system flush buffer_cache; 系统已更改。 SQL> set autotrace on; SQL> select * 2 from COUNTRIES c, 3 REGIONS r 4 where c.REGION_ID=r.REGION_ID and c.REGION_ID='4'; REGIONS r * 第 3 行出现错误: ORA-00942: 表或视图不存在 SQL> select * 2 from hr.COUNTRIES c, 3 hr. 网站seo优化诊断工具REGIONS r 4 where c.REGION_ID=r.REGION_ID and c.REGION_ID='4'; CO COUNTRY_NAME REGION_ID REGION_ID -- ---------------------------------------- ---------- ---------- REGION_NAME ------------------------- EG Egypt 4 4 Middle East and Africa IL Israel 4 4 Middle East and Africa KW Kuwait 4 4 Middle East and Africa CO COUNTRY_NAME REGION_ID REGION_ID -- ---------------------------------------- ---------- ---------- REGION_NAME ------------------------- NG Nigeria 4 4 Middle East and Africa ZM Zambia 4 4 Middle East and Africa ZW Zimbabwe 4 4 Middle East and Africa 已选择6行。 执行计划 ---------------------------------------------------------- Plan hash value: 4030513296 -------------------------------------------------------------------------------- ---------------- | Id | Operation | Name | Rows | Bytes | Cost (% CPU)| Time | -------------------------------------------------------------------------------- ---------------- | 0 | SELECT STATEMENT | | 6 | 168 | 2 (0)| 00:00:01 | | 1 | NESTED LOOPS | | 6 | 168 | 2 (0)| 00:00:01 | | 2 | TABLE ACCESS BY INDEX ROWID| REGIONS | 1 | 14 | 1 (0)| 00:00:01 | |* 3 | INDEX UNIQUE SCAN | REG_ID_PK | 1 | | 0 (0)| 00:00:01 | |* 4 | INDEX FULL SCAN | COUNTRY_C_ID_PK | 6 | 84 | 1 (0)| 00:00:01 | -------------------------------------------------------------------------------- ---------------- Predicate Information (identified by operation id): --------------------------------------------------- 3 - access("R"."REGION_ID"=4) 4 - filter("C"."REGION_ID"=4) 统计信息 -------------------网站建设多少钱--------------------------------------- 628 recursive calls 0 db block gets 127 consistent gets 20 physical reads 0 redo size 825 bytes sent via SQL*Net to client 385 bytes received via SQL*Net from client 2 SQL*Net roundtrips to/fr网站seo优化课程om client 13 sorts (memory) 0 sorts (disk) 6 rows processed SQL> ############# SQL> alter system flush shared_pool; 系统已更改。 SQL> alter system flush buffer_cache; 系统已更改。 select * from hr.COUNTRIES c, hr. REGIONS r where c.REGION_ID='4' 6 and c.REGION_ID=r.REGION_ID; CO COUNTRY_NAME REGION_ID REGION_ID -- ---------------------------------------- ---------- ---------- REGION_NAME ------------------------- EG Egypt 4 4 Middle East and Africa IL Israel 4 4 Middle East and Africa KW Kuwait 4 4 Middle East and Africa CO COUNTRY_NAME REGION_ID REGION_ID -- ---------------------------------------- ---------- ---------- REGION_NAME ------------------------- NG Nigeria 4 4 Middle East and Africa ZM Zambia 4 4 Middle East and Africa ZW Zimbabwe 4 4 Middle East and Africa 已选择6行。 执行计划 ---------------------------------------------------------- Plan hash value: 4030513296 -------------------------------------------------------------------------------- ---------------- | Id | Operation | Name | Rows | Bytes | Cost (% CPU)| Time | -------------------------------------------------------------------------------- ---------------- | 0 | SELECT STATEMENT | | 6 | 168 | 2 (0)| 00:00:01 | | 1 | NESTED LOOPS | | 6 | 168 | 2 (0)| 00:00:01 | | 2 | TABLE ACCESS BY INDEX ROWID| REGIONS | 1 | 14 | 1 (0)| 00:00:01 | |* 3 | INDEX UNIQUE SCAN | REG_ID_PK | 1 | | 0 (0)| 00:00:01 | |* 4 | INDEX FULL SCAN | COUNTRY_C_ID_PK | 6 | 84 | 1 (0)| 00:00:01 | -------------------------------------------------------------------------------- ---------------- Predicate Information (identified by operation id): --------------------------------------------------- 3 - access("R"."REGION_ID"=4) 4 - filter("C"."REGION_ID"=4) 统计信息 ---------------------------------------------------------- 656 recursive calls 0 db block gets 131 consistent gets 22 physical reads 0 redo size 825 bytes sent via SQL*Net to client 385 bytes received via SQL*Net from client 2 SQL*Net roundtrips to/from client 13 sorts (memory) 0 sorts (disk) 6 rows processed SQL>相关网站优化seo培训公司网站建设。

关键词标签: 不同 示例

声明: 本文由我的SEOUC技术文章主页发布于:2023-05-24 ,文章where条件顺序不同、性能不同示例探讨建站知识主要讲述不同,示例,where条件顺序不同、性能不同示例探讨网站建设源码以及服务器配置搭建相关技术文章。转载请保留链接: https://www.seouc.com/article/web_6751.html

我的IDC 网站建设技术SEOUC.COM
专注网站建设,SEO优化,小程序设计制作搭建开发定制网站等,数千家网站定制开发案例,网站推广技术服务。
  • 5000+合作客服
  • 8年从业经验
  • 150+覆盖行业
  • 最新热门源码技术文章