求助:SQL語句優化
select b.userlabel,
b.zh_label,
a.ftp0,
a.ftp1,
a.ftp2,
a.ftp3,
b.int_id,
b.object_class,
a.resource_status,
a.org_severity,
a.org_type,
d.remark_txt,
a.event_time,
a.probable_cause,
b.province_id,
b.province_id || ':' || b.city_id as region,
b.region_id,
b.vendor_id,
a.redefine_severity,
a.redefine_type,
a.active_status,
a.ack_flag,
a.alarm_title,
a.cancel_time,
a.ack_time,
a.ack_user,
a.omc_id,
a.cancel_terminal,
a.cancel_user,
a.ack_terminal,
a.locate_info,
a.probable_cause_txt,
a.vendor_severity,
a.vendor_type,
c.special_field0,
c.special_field1,
c.special_field2,
c.special_field3,
c.special_field4,
c.special_field5,
c.special_field6,
c.special_field7,
c.special_field8,
c.special_field9,
c.special_field10,
c.special_field11,
c.special_field12,
c.special_field13,
c.special_field14,
c.special_field15,
c.special_field16,
c.special_field17,
c.special_field18,
c.special_field19,
c.special_field20,
a.time_stamp,
c.alarm_text0,
c.alarm_text1,
c.alarm_text2,
c.alarm_text3,
c.alarm_text4,
c.alarm_text5,
c.alarm_text6,
c.alarm_text7,
c.alarm_text8,
c.alarm_text9,
c.alarm_text10,
c.alarm_text11,
c.alarm_text12,
c.alarm_text13,
c.alarm_text14,
c.alarm_text15
from a, b, c, d
where (a.event_time BETWEEN
TO_DATE('2009-03-03 10:00:00', 'YYYY-MM-DD HH24:MI:SS') AND
TO_DATE('2009-03-03 12:00:00', 'YYYY-MM-DD HH24:MI:SS')) AND
a.int_id = b.int_id AND
a.object_class = b.object_class AND
a.ftp0 = d.ftp0(+) AND
a.ftp1 = d.ftp1(+) AND
a.ftp2 = d.ftp2(+) AND
a.ftp3 = d.ftp3(+) AND
a.ftp0 = c.ftp0(+) AND
a.ftp1 = c.ftp1(+) AND
a.ftp2 = c.ftp2(+) AND
a.ftp3 = c.ftp3(+) AND
(a.resource_status in (1))
這個SQL語句怎麼優化,大家誰有好的的辦法?謝謝了,希望大家幫幫忙~~~~
b.zh_label,
a.ftp0,
a.ftp1,
a.ftp2,
a.ftp3,
b.int_id,
b.object_class,
a.resource_status,
a.org_severity,
a.org_type,
d.remark_txt,
a.event_time,
a.probable_cause,
b.province_id,
b.province_id || ':' || b.city_id as region,
b.region_id,
b.vendor_id,
a.redefine_severity,
a.redefine_type,
a.active_status,
a.ack_flag,
a.alarm_title,
a.cancel_time,
a.ack_time,
a.ack_user,
a.omc_id,
a.cancel_terminal,
a.cancel_user,
a.ack_terminal,
a.locate_info,
a.probable_cause_txt,
a.vendor_severity,
a.vendor_type,
c.special_field0,
c.special_field1,
c.special_field2,
c.special_field3,
c.special_field4,
c.special_field5,
c.special_field6,
c.special_field7,
c.special_field8,
c.special_field9,
c.special_field10,
c.special_field11,
c.special_field12,
c.special_field13,
c.special_field14,
c.special_field15,
c.special_field16,
c.special_field17,
c.special_field18,
c.special_field19,
c.special_field20,
a.time_stamp,
c.alarm_text0,
c.alarm_text1,
c.alarm_text2,
c.alarm_text3,
c.alarm_text4,
c.alarm_text5,
c.alarm_text6,
c.alarm_text7,
c.alarm_text8,
c.alarm_text9,
c.alarm_text10,
c.alarm_text11,
c.alarm_text12,
c.alarm_text13,
c.alarm_text14,
c.alarm_text15
from a, b, c, d
where (a.event_time BETWEEN
TO_DATE('2009-03-03 10:00:00', 'YYYY-MM-DD HH24:MI:SS') AND
TO_DATE('2009-03-03 12:00:00', 'YYYY-MM-DD HH24:MI:SS')) AND
a.int_id = b.int_id AND
a.object_class = b.object_class AND
a.ftp0 = d.ftp0(+) AND
a.ftp1 = d.ftp1(+) AND
a.ftp2 = d.ftp2(+) AND
a.ftp3 = d.ftp3(+) AND
a.ftp0 = c.ftp0(+) AND
a.ftp1 = c.ftp1(+) AND
a.ftp2 = c.ftp2(+) AND
a.ftp3 = c.ftp3(+) AND
(a.resource_status in (1))
這個SQL語句怎麼優化,大家誰有好的的辦法?謝謝了,希望大家幫幫忙~~~~
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/751371/viewspace-563133/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- SQL語句優化SQL優化
- SQL Server優化之SQL語句優化SQLServer優化
- MYSQL SQL語句優化MySql優化
- sql語句效能優化SQL優化
- SQL語句的優化SQL優化
- MySQL之SQL語句優化MySql優化
- SQL語句優化(轉載)SQL優化
- 常用SQL語句優化技巧SQL優化
- Oracle之sql語句優化OracleSQL優化
- SQL 語句的優化方法SQL優化
- 優化 SQL 語句的步驟優化SQL
- 一個SQL語句的優化SQL優化
- Oracle SQL語句優化之UNIONOracleSQL優化
- SQL語句操作符優化SQL優化
- 關於sql語句的優化SQL優化
- SQL語句優化技術分析SQL優化
- SQL語句優化方法30例SQL優化
- 一條sql語句的優化SQL優化
- sql語句的優化案例分析SQL優化
- 資料庫效能優化之SQL語句優化資料庫優化SQL
- 淺談mysql配置優化和sql語句優化MySql優化
- 通過分析SQL語句的執行計劃優化SQL語句SQL優化
- 對sql語句的優化問題SQL優化
- oracle效能問題:sql語句優化OracleSQL優化
- SQL語句優化方法30例(轉)SQL優化
- SQL語句優化--十條經驗SQL優化
- 優化SQL 語句 in 和not in 的替代方案優化SQL
- ORACLE SQL語句優化技術分析OracleSQL優化
- 通過SQL PROFILE自動優化SQL語句SQL優化
- 主動優化高負載SQL語句優化負載SQL
- SQL Server之資料庫語句優化SQLServer資料庫優化
- SQLServer效能優化之改寫SQL語句SQLServer優化
- 一條SQL語句的優化過程SQL優化
- ORACLE SQL語句優化技術分析(zt)OracleSQL優化
- 一次sql語句優化的反思SQL優化
- ORACLE SQL語句優化技術分析(轉)OracleSQL優化
- SQL Server 之資料庫語句優化SQLServer資料庫優化
- [zt] 基於索引的SQL語句優化索引SQL優化