view is virtual table and index is created on table columns which is perfor

Differnce between view and index

Question Posted / kamala k n

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

Please Help Members By Posting Answers For Below Questions

How to define an anonymous block?

1071

What is save point in oracle database?

1239

Explain constraining triggers.

1042

Is oracle an open source?

1019

How to convert characters to times in oracle?

953

How to convert characters to dates in oracle?

1022

Is rowid unique in oracle?

937

Explain an index segment?

1039

How to add a new column to an existing table in oracle?

1068

Difference between oracle's plus (+) notation and ansi join notation?

1031

What are the uses of Database Trigger ?

1623

How to build data dictionary view an new database?

957

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

1090

What do you mean by a tablespace?

980

Explain how are indexes update?

1013