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

What is the difference between view and materialized view in Oracle?

870


What is an oracle wallet?

680


What is the oracle implicit cursor?

795


How do I find my oracle client driver version?

741


I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?

878


What is a initialization parameter file in oracle?

785


How index is implemented in oracle database?

781


What is the difference between a user and a schema in oracle?

820


What is the usage of merge statement?

890


What is the scope of a local variable?

769


what are archived logs?

1945


How to handle a single quote in oracle sql?

795


11. Display the client number and name and the client number and name of the person who referred that client.

2095


What are the uses of synonyms?

847


Explain index?

1003