Differnce between view and index

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


Please Help Members By Posting Answers For Below Questions

How to join two tables in a single query using oracle?

783


what are the advantages of running a database in archive log mode?

1978


How to create a stored procedure in oracle?

817


What is the quickest way to fetch the data from a table?

829


How to convert character types to numeric types?

804


15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.

2034


State and explain the different types of data models?

745


What is oracle datasource?

775


How to retrieve data from an cursor to a record?

783


What are the different editions of oracle?

849


What is the difference between sharding and replication?

704


what is reindexing?

1378


Why use resource manager in Oracle?

884


Explain database link?

889


Which dictionary tables and/or views would you look at to diagnose a locking issue?

1704