tom说最近问题的质量下降了

[url=http://www.blogger.com/][img=150,40]http://www.blogger.com/img/logo40.png[/img][/url] [i]Push-Button Publishing[/i]




Thomas Kyte[list][*][b]年龄:[/b] 43[*][b]性别:[/b] 男[*][b]星座：[/b] 双鱼座[*][b]生肖：[/b] 蛇[*][b]行业：[/b] [url=http://www.blogger.com/profile-find.g?t=j&ind=TECHNOLOGY][color=#0000ff]科技[/color][/url][*][b]职业：[/b] [url=http://www.blogger.com/profile-find.g?t=o&q=Database+Technologist][color=#0000ff]Database Technologist[/color][/url][*][b]地点:[/b] [url=http://www.blogger.com/profile-find.g?t=l&loc0=US&loc1=Virginia&loc2=Round+Hill][color=#0000ff]Round Hill[/color][/url] : [url=http://www.blogger.com/profile-find.g?t=l&loc0=US&loc1=Virginia][color=#0000ff]Virginia[/color][/url] : [url=http://www.blogger.com/profile-find.g?t=l&loc0=US][color=#0000ff]美国[/color][/url][/list]我的简介The views expressed are my own and not necessarily those of Oracle and its affiliates. The views and opinions expressed by visitors to this blog are theirs and do not necessarily reflect mine. I've been using Oracle since 1988. I've been working at Oracle since 1993 (version 7.0). I spend way too much time working on asktom.oracle.com...
兴趣[list][*][url=http://www.blogger.com/profile-find.g?t=i&q=Oracle][color=#0000ff]Oracle[/color][/url][*][url=http://www.blogger.com/profile-find.g?t=i&q=Databases][color=#0000ff]Databases[/color][/url][*][url=http://www.blogger.com/profile-find.g?t=i&q=My+kids][color=#0000ff]My kids[/color][/url][*][url=http://www.blogger.com/profile-find.g?t=i&q=Science+Fiction][color=#0000ff]Science Fiction[/color][/url][*][url=http://www.blogger.com/profile-find.g?t=i&q=World+Events][color=#0000ff]World Events[/color][/url][/list]喜爱的电影[list][*][url=http://www.blogger.com/profile-find.g?t=m&q=Most+any+by+Woody+Allen.][color=#0000ff]Most any by Woody Allen.[/color][/url][/list]喜爱的音乐[list][*][url=http://www.blogger.com/profile-find.g?t=s&q=All+kinds+from+Classical+to+Rock+%28but+not+the+80%27s+%3A%29][color=#0000ff]All kinds from Classical to Rock (but not the 80's :)[/color][/url][/list]喜爱的书[list][*][url=http://www.blogger.com/profile-find.g?t=b&q=Hitchhikers+Guides][color=#0000ff]Hitchhikers Guides[/color][/url][*][url=http://www.blogger.com/profile-find.g?t=b&q=Asimov+Robot+Series][color=#0000ff]Asimov Robot Series[/color][/url][/list]Thomas Kyte的博客[table][tr] Blog 名团队成员[/tr][tr][td][img=18,18]http://www.blogger.com/img/icon18_editdoc.gif[/img][/td][url=http://loudoun95white.blogspot.com/][color=#0000ff]Loudoun Soccer 95G White[/color][/url][td][url=http://www.blogger.com/profile/16827173817489349602][color=#0000ff]Coach Ed[/color][/url] [url=http://www.blogger.com/profile/09111082135548092987][color=#0000ff]Loudoun Magic[/color][/url] [/td][/tr][tr][td][img=18,18]http://www.blogger.com/img/icon18_editdoc.gif[/img][/td][url=http://tkyte.blogspot.com/][color=#800080]The Tom Kyte Blog[/color][/url][td] [/td][/tr][/table]



照片[align=center][url=http://bp1.blogger.com/_Adb4DobPwb8/R2xg_0csoTI/AAAAAAAAAAM/7t61_vOHXSA/S220-h/tkyte.jpg][img=151,113]http://bp1.blogger.com/_Adb4DobPwb8/R2xg_0csoTI/AAAAAAAAAAM/7t61_vOHXSA/S220/tkyte.jpg[/img][/url][/align]
[align=center][url=http://bp1.blogger.com/_Adb4DobPwb8/R2xg_0csoTI/AAAAAAAAAAM/7t61_vOHXSA/S220-h/tkyte.jpg][color=#0000ff]全屏显示[/color][/url][/align]



联系人[list][*][url=http://asktom.oracle.com/][color=#0000ff]我的网页[/color][/url][/list]


用户统计信息[table][tr]Blogger 始用于[td]2005-04[/td][/tr][tr]个人资料查看次数[td]67,436[/td][/tr][/table]



[url=http://www.blogger.com/][color=#800080]主页[/color][/url] | [url=http://www.blogger.com/about][color=#0000ff]关于[/color][/url] | [url=http://buzz.blogger.com/][color=#0000ff]快讯[/color][/url] | [url=http://help.blogger.com/][color=#0000ff]帮助[/color][/url] | [url=http://www.blogger.com/language.g][color=#800080]语言[/color][/url] | [url=http://code.blogspot.com/][color=#0000ff]开发人员[/color][/url] | [url=http://www.googlestore.com/category.asp?catid=search&searchtype=keyword&search=blogger][color=#0000ff]商店[/color][/url]
[url=http://www.blogger.com/terms.g][color=#0000ff]服务条款[/color][/url] | [url=http://www.blogger.com/privacy][color=#0000ff]隐私权[/color][/url] | [url=http://www.blogger.com/content.g][color=#0000ff]内容政策[/color][/url] | © 1999 – 2008 Google

Tuesday, June 10, 2008I don't know...
I don't know if
a) I'm getting grumpier as I get older
b) people are losing the ability to phrase a question.  
It just seems to me that day by day, the quality of the questions goes down.  I don't remember people asking questions like this just 8 years ago.  I've been participating in forums since 1994.  "Back in the day", the questions were mostly thought out, with examples - with some background, with some thought.  In the last couple of years - this seems to be changing - universally.
Oh well, it is probably related to both bullet points... Anyway here is the QOD - question of the day.
[i]Subject: query is not using particular partition and index despite use full table scan[/i]
[i]Entire question:[/i]
[i]SELECT count(*)
FROM
DIM_BANK RIGHT OUTER JOIN FACT_JRNL_ACTG ON (DIM_BANK.BANK_ID=FACT_JRNL_ACTG.BANK_ID)
LEFT OUTER JOIN DIM_BSA ON (FACT_JRNL_ACTG.BSA_ID=DIM_BSA.BSA_ID)
LEFT OUTER JOIN DIM_FY ON (FACT_JRNL_ACTG.FY_ID=DIM_FY.FY_ID)
LEFT OUTER JOIN DIM_APD ON (FACT_JRNL_ACTG.APD_ID=DIM_APD.APD_ID)
LEFT OUTER JOIN DIM_PSCD ON (FACT_JRNL_ACTG.PSCD_ID = DIM_PSCD.PSCD_ID)
WHERE
(
(DIM_BANK.BANK_ACCT_CD IN ('33')
OR '*' IN ('33'))
AND DIM_PSCD.PSCD_CLOS_CL_CD IN ('1', '4', '5')
AND CASE DIM_BSA.CASH_ACCT_FL WHEN 0 THEN 'No' WHEN 1 THEN 'Yes' END = 'Yes'
AND DIM_APD.PER != 0
AND DIM_APD.PER != 99
AND DIM_APD.FY < 2008
OR DIM_FY.FY = 2008
AND DIM_APD.PER <= 6
AND DIM_APD.PER != 0
AND CASE DIM_BSA.CASH_ACCT_FL WHEN 0 THEN 'No' WHEN 1 THEN 'Yes' END = 'Yes'
AND DIM_PSCD.PSCD_CLOS_CL_CD IN ('1', '4', '5')
AND (DIM_BANK.BANK_ACCT_CD IN ('33')
OR '*' IN ('33'))
); [/i]

That's it folks.  "My query isn't doing partition elimination (probably, I'm sort of GUESSING) and isn't using some index (on some column of some table)"
Before anyone says anything - this comes from the US.
Some wows from reading the query:
[list][*]"(DIM_BANK.BANK_ACCT_CD IN ('33') OR '*' IN ('33')) - why would you do that?[*]"CASE DIM_BSA.CASH_ACCT_FL WHEN 0 THEN 'No' WHEN 1 THEN 'Yes' END = 'Yes'" - why would you do THAT?[*]"CASE DIM_BSA.CASH_ACCT_FL WHEN 0 THEN 'No' WHEN 1 THEN 'Yes' END = 'Yes'" - just in case you didn't believe us the first time[*]wow, more duplicated predicates...[*]outer joins to DIM_BSA, but we have that neat predicate using CASE - if we actually needed to outer join to DIM_BSA then all of the attributes would be NULL - the predicate would never be true - hence, we do not need or want to outer join to DIM_BSA[*]Same comment about DIM_FY, we outer join to DIM_FY, but if we make up a row - then DIM_FY's attributes will all be null and DIM_FY.FY = 2008 cannot be true (or false, it is unknown)[*]Ditto for DIM_APD[*]and of course DIM_PSCD[*]and just to make it 100% complete, the outer join to DIM_BANK - ditto. [b]every single outer join in this query, should not be there.[/b][/list]I've responded with:
My car won't start.  Now we are even, we have shared the same level of detail regarding our respective problems.



[font=Trebuchet MS][size=1][color=#999999]posted by Thomas Kyte at [/color][/size][/font][url=http://tkyte.blogspot.com/2008/06/i-don-know.html][font=Trebuchet MS][size=1][color=#5588aa]3:44 PM[/color][/size][/font][/url] [url=http://tkyte.blogspot.com/2008/06/i-don-know.html#comments][font=Trebuchet MS][size=1][color=#5588aa]79 Comments, Read/Add them... [/color][/size][/font][/url][url=http://www.blogger.com/email-post.g?blogID=11839365&postID=3368830988477488894][font=Trebuchet MS][size=1][color=#5588aa][img]http://www.blogger.com/img/icon18_email.gif[/img][/color][/size][/font][/url][url=http://www.blogger.com/post-edit.g?blogID=11839365&postID=3368830988477488894][font=Trebuchet MS][size=1][color=#5588aa][img]http://www.blogger.com/img/icon18_edit_allbkg.gif[/img][/color][/size][/font][/url]

TOM 可能回答重复的问题太多了～～

tom人家要带孙子了．

现在学oracle的人多了，自然问题质量要下降，而且他肯定也回答不过来啊

其实搜索引擎与  Blog 和 Wiki 对 Tom的冲击也挺大的

以前信息源没那么多，自然会有很多好问题，现在就不那么一样了

TOM的高度和理解的程度是令人望尘莫及的，非常尊敬这位大叔

敬佩！

仰慕TOM

TOM，世界一流Oracle专家！偶像！

关键学数据库的人中，不动脑子等现成的 人多了

a) I'm getting grumpier as I get older  
    非常能够理解，就好像有人突然问的什么是b-tree索引，你怎么回答
b) people are losing the ability to phrase a question.  
    PUB里也可这种感觉

不过我还刚起步，需以要心平气和，也希望大师们能理解我们这些新手。

呵呵!何止是问问题的质量下降了.连解答问题的帖子的质量都下降了.一知半解就解答.重复的发一些什么完全安装手册呀什么的.真正详细权威的安装手册就放在那里就是不看.唉,真像egyle所说的连发廊都用Oracle了,呵呵!看来没有OCM还真是不行了.

还有一帮根本就不懂也不想懂得人一看见什么帖子就跟贴说什么学习了,也不好好的研究,真是很无聊.

bcz more more ppl start using EM :)

嗯，看来这也是个全球化的问题，我也感觉很多问题和回帖的质量都下降了，pub现在也不经常上了

Tom是搞oracle开发的，还是技术支持的？
拉尔森的oracle水平怎么样？
这些问题有谁知道吗？

itpub的问题质量也下降了:)

高手都下山了？  

让我们组织第二梯队上！！！

[[i] 本帖最后由 owlstudio 于 2008-7-4 16:21 编辑 [/i]]

TOM 好退休了