Answer Posted / kamala k n
view is virtual table and index is created on table columns which is performance the query
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to join two tables in a single query using oracle?
what are the advantages of running a database in archive log mode?
How to create a stored procedure in oracle?
What is the quickest way to fetch the data from a table?
How to convert character types to numeric types?
15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.
State and explain the different types of data models?
What is oracle datasource?
How to retrieve data from an cursor to a record?
What are the different editions of oracle?
What is the difference between sharding and replication?
what is reindexing?
Why use resource manager in Oracle?
Explain database link?
Which dictionary tables and/or views would you look at to diagnose a locking issue?