Indexes in oracle ?
Answers were Sorted based on User's Feedback
Answer / ramprasad.s
Hi
Indexes in oracle are to retrieve the data from the
database at a faster rate
bye
sun_ramprasad@yahoo.com
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / basanti
Hello
Index is a database object which is use to access data
faster its like content page in a book
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / radha
Indexes in Oracle are:
(create <type of index> index <indexname> on <tablename>
(<colname>)
1. B-Tree (regular indexing algorithm )
2. Bitmap (for low cardinality fields.
By default oracle creates bitmap Index)
3. Partitioned indexes (for manageability
and to distribute I/O evenly)
4. Function based indexes (when you want
to index a function based calculation itself)
5. IOTs (Index organised tables - Table and
Index combined into one)
6. Domain Indexes (using user defined index types)
Is This Answer Correct ? | 0 Yes | 2 No |
HOW TO CONVERT ORACLE TABLE DATA (RECORDS)INTO EXCEL SHEEET?
What is Parallel Server ?
What is Segment Advisor in Oracle?
how to produce numbers from 1 to 10 using dual table
5. Display full details from the ORDER_LINE table where the item number is (first condition) between 1 and 200 (no > or < operators) OR the item number is greater than 1000 AND (second condition) the item cost is not in the list 1000, 2000, 3000 OR the order number is not equal to 1000.
How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.
How do I uninstall oracle client from windows?
what is data abstraction
In Oracle 9i what does "i" Stands for?
What is data block in Oracle?
How to apply filtering criteria at group level in oracle?
what are indexes..how many types of index's are there and what are they?
7 Answers Green Info Solutions, TCS,