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

15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.

2350

what is the use of system.effective.date variable in oracle?

1161

How to return top 5 rows in oracle?

1112

How to rename an existing table?

1206

What is the fastest query method to fetch data from the table?

1411

How to manage transaction isolation level?

1054

What is meant by recursive hints in oracle?

1127

What is a procedure in oracle?

1276

What happens to the indexes if a table is recovered?

1043

What is partitioned table in Oracle?

1264

What is a dynamic performance view in oracle?

1049

Can a formula column referred to columns in higher group ?

2550

How to execute the package in oracle?

1132

How to retrieve the count of updated rows?

1184

How to use existing values in update statements using oracle?

1110