Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
Latest Answer: PARTITION is one of the options, which you can enable when you install Oracle Enterprice Edition.You may enable it later if you didn't choose to install at first time. You will have to install again by using OUI and choose the PARTITION option ...
Latest Answer: Thanks for the information! ...
I am getting error "No Communication channel" after changing the domain name? what is the solution?
Latest Answer: And.. It does not store any data value in it unlike normal index do.Queries will not get benefitted. This can be used only for analysis. ...
Virtual Indexes are another undocumented feature used by Oracle. Virtual indexes, as the name suggests are pseudo-indexes that will not behave the same way that normal indexes behave, and are meant for
Latest Answer: Query Rewrite option advantages we can get with the materialize view option also. ...
Latest Answer: Function-based indexes can use any Function or Object method that is declared as repeatable. Queries using expressions can use the index. Ex:- CREATE INDEX sales_margin_inx ON sales(revenue - cost); Sql> SELECT ...
Latest Answer: The explanations are above, read further in the concepts manual.I would advice caution when using these, as they can cause severe conention when used in Update/Insert Intensive / OLTP environs.This is because of the way the bitmap index is organized:Value1:rowid,rowid,rowid........Value2:rowid,rowid,rowid........ ...
View page << Previous 10 11 12 13 [14] 15 16 17 18 19 Next >>
Go Top
