tag:blogger.com,1999:blog-18037024.post6315286372094292990..comments2024-02-16T14:33:11.277+01:00Comments on Annals of Oracle's Improbable Errors: Function-based indexes and the easy life of a database developerByte64http://www.blogger.com/profile/15629209362377395020noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-18037024.post-78155051296706799522009-07-31T09:58:28.525+02:002009-07-31T09:58:28.525+02:00Good question Mark,
actually i don't know.
I&#...Good question Mark,<br />actually i don't know.<br />I'd need to perform a test to confirm or deny, this kind of scenarios needs to be tested whatever the documentation says or doesn't.<br /><br />Thank you<br />FlavioByte64https://www.blogger.com/profile/15629209362377395020noreply@blogger.comtag:blogger.com,1999:blog-18037024.post-52993565840520140972009-07-28T21:51:48.714+02:002009-07-28T21:51:48.714+02:00Does 10g automatically gather stats on the hidden ...Does 10g automatically gather stats on the hidden columns it creates for function-based indexes or is it still necessary to run gather_table_stats on every table with a function_based index with method_opt=>'FOR ALL HIDDEN COLUMNS SIZE 1'?Mark Freeman (@m60freeman)https://www.blogger.com/profile/11475488917130342878noreply@blogger.comtag:blogger.com,1999:blog-18037024.post-48682106695752919532008-10-31T17:02:00.000+01:002008-10-31T17:02:00.000+01:00This type of thing is why I got in the habit of al...This type of thing is why I got in the habit of always issues a <BR/><BR/>exec dbms_stats.gather_table_stats<BR/><BR/>after I create a new index. Even though I am now working on 11gR1 I still do this. I guess I don't want to leave it up to chance.Tonyhttps://www.blogger.com/profile/12184354575866057215noreply@blogger.comtag:blogger.com,1999:blog-18037024.post-14458788071805356952008-10-31T14:30:00.000+01:002008-10-31T14:30:00.000+01:00Nice anecdote.Nice anecdote.Anonymousnoreply@blogger.com