Why You Need Indexing? Where That Is Stored And What You Mean By Sche

1.	Why You Need Indexing? Where That Is Stored And What You Mean By Schema Object? For What Purpose We Are Using View?
Answer» We can't create an Index on Index.. Index is stoed in user_index table. Every object that has been created on Schema is Schema Object like Table, VIEW etc. If we want to share the particular data to various users we have to use the VIRTUAL table for the BASE table. So that is a view. Indexing is used for faster search or to retrieve data faster from various table. Schema containing set of tables, basically schema means logical separation of the database. View is crated for faster retrieval of data. It's customized virtual table. we can create a SINGLE view of multiple tables. Only the drawback is..view NEEDS to be get refreshed for retrieving updated data.

Why You Need Indexing? Where That Is Stored And What You Mean By Schema Object? For What Purpose We Are Using View?

Answer»

We can't create an Index on Index.. Index is stoed in user_index table. Every object that has been created on Schema is Schema Object like Table, VIEW etc. If we want to share the particular data to various users we have to use the VIRTUAL table for the BASE table. So that is a view.
Indexing is used for faster search or to retrieve data faster from various table. Schema containing set of tables, basically schema means logical separation of the database. View is crated for faster retrieval of data. It's customized virtual table. we can create a SINGLE view of multiple tables. Only the drawback is..view NEEDS to be get refreshed for retrieving updated data.