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 background process in Oracle?

624


How to unlock the sample user account in oracle?

556


What is query image?

584


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.

1502


HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE

1781






How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?

2722


What happens to the data files if a tablespace is dropped?

574


Hi friends can u send the oracle 9i full version download link?????????????? please reply ?

1440


Explain oracle data types with examples?

575


What is connection pooling in oracle?

550


For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?

1554


Explain the use of show option in imp command.

638


Explain the blob datatype?

612


How to load a large xml file?

580


What is save point in oracle database?

725