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 connect to the server with user account: sys?

1010

What is coalesce function?

1062

How to export data to a csv file?

1289

Give the various rollback segment states.

1046

what happened to the global index when I truncate the data in one of the partition?

2014

What is a proxy class?

1037

What are the differences between date and timestamp in oracle?

1041

what is the scenario where you take the database to NoArchivelog mode?

2321

What is an external table?

1011

Explain oracle’s server parameter file.

983

Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?

1079

How many types of tables are there in oracle?

1052

What is primefaces used for?

1045

Explain an index segment?

1102

What is translate in oracle?

1090