What is index? How many types of indexes?
Answers were Sorted based on User's Feedback
Answer / kishore
Index is a performance tuning method of allowing faster
retrieval of records. Oracle indexing is a standing B-Tree
indexing for fast retrieval.
Syntax: CREATE INDEX EmpInfo ON Employee(EmpID,Emp_Name)
we have two types indexes
1. Clustered indexes
2. Non-Clustred indexes
| Is This Answer Correct ? | 36 Yes | 9 No |
Answer / ruchi
index is a data structure used for fast retrival of data.
| Is This Answer Correct ? | 7 Yes | 3 No |
i want to know about the javaBean.what is its purpose and how it can use in Forms.
How to move the data from one flatfile to multiple staging tables?give me some examples? for example in po interface one flat file is there and multiple staging tables are there how can move it?please give me answer for this question?
Hi, I want to know basic information about Oracle HRMS and the institutes in hyderabad or the best faculty as i want to make my career in it.And also want to know may a person from non technical background be able to do this course. Regards, Swetha
What are the mandatory setups in setting up a PO in oracle
Name a tablespace automatically created when you create a database.
which gives Oracle R12 Financial training in delhi please give me answer its urgent?
CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?
hi all, i have installed oracle xe software in windows 7. iam unable to connect sqldeveloper tool. can you please tell me how to connect. provide completed procedure.
Give the reasoning behind using an index.
Describe what redo logs are.
What background process refreshes materialized views?
what is the difference b/w oracle8i and oracle9i