Interested to Buy Any Domain ? << Click Here >> for more details...
Differnce between view and index
- 3 Answers
- 6030 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / pravin patil
Vies is logical representaion of parent table
& index is oralce object use to access table' column quickly
view can replace but index cannot replace u have to delect
existed index then create new index.
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / 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 |
Answer / 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 |
Explain the truncate in oracle?
i have executed the Delete command after the I have created table whether deletions will be commit or not? if table is successfully created?
How can I combine multiple rows into a comma-delimited list in oracle?
Define 'view' advantage ?
SELECT THE RECORDS FROM 3 TABLES LIKE(T1,T2,T3) AND HOW CAN WE INSERT THAT RECORD IN ANOTHER TABLE LIKE(T4)?
How to write a query with an inner join in oracle?
How do I escape a reserved word in oracle?
Give the various exception types.
If I have a select statment which retrives 2 rows, & that rows have the same data in all the fields except the last field and I want to merge the 2 rows to be in 1 row with concatenating the last field which have the different data.... eg: the 1st row has these fields: A-B-C the second row has: A-B-X ........ i want to merge the two row to be in one row like ----> A- B- C,X
How can Oracle users be audited?
How to get execution statistics reports on query statements?
dear sir/madam, i have done my engg in 2007 after that i did oracle course (sql,plsql,forms,reports) .from 2008 to 2009 i searched job but didnt got.so i planned to move to sales field & i gone to dubai.till now i m in sales only.now i want to shift my career in to IT industry.but now people are not hiring as fresher.so i planned put fake 1 + exp. is it good or bad or any other way is there to enter in IT.please suggest me or call me 09632087338.
Oracle General 
