Differnce between view and index

Answer Posted / sahaja mallarapu

A View is a data base object also called as virtual table
which is created on a select statement.
A view can be created using multiple tables.
A view is stored in a temporary memory.

An index is also a DB Object which is used to increase
query performance and index is created based on columns of
a table.
An index is created on multiple columns but on a single
table.
Index is maintained by Oracle Server itself.

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can we find out the current date and time in oracle?

852


How can I convert single byte kana characters into multi byte kana characters and vice-versa.

2169


What is the difference between substr and instr?

739


What is system global area (sga) in oracle?

791


What are the different types of trigger and explain its various uses and functions?

757


Explain the use of parfile option in exp command.

766


How do you tell what your machine name is and what is its IP address?

1771


What is the purpose of save points in oracle database?

748


what is the use of triggers in Java program? I mean where do we use triggers in Java programming?

1964


1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE

1791


Explain the use of compress option in exp command.

768


How to create a new tablespace in oracle?

764


State all possible different index configurations a table can possibly have?

794


What is oracle analytical function?

780


What do you mean by redo log file mirroring?

769