Answer Posted / ashok naik
Yes that is called indexed views using this we can improve
Query performance if your view contain single select
stament then we can easily establish unique clusterd index
Is This Answer Correct ? | 63 Yes | 20 No |
Post New Answer View All Answers
What is oracle host variable?
From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.
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 do you mean by merge in oracle and how can we merge two tables?
Explain oracle instance.
What is a cognitive schema?
How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?
What is the relationship among database, tablespace and data file?
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
In what script is snap$ created? In what script is the scott/tiger schema created?
What are the numeric comparison operations?
What do you understand by database schema and what does it hold?
How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.
Hi Can any one tell me what are the API's used in requisition import.
how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?