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 |
What is the recommended interval at which to run statspack snapshots, and why?
How to get a list of all tables in the database?
What are the oracle built-in data types?
Can we save images in a database and if yes, how?
how to find out second largest value in the table
How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?
How to start instance with a minimal initialization parameter file?
How can one skip any number of rows while loading the DB tables with SQL Loader? Similarly how can one skip any column?
What is an Oracle view?
how can get like this result table A col1 col2 --- ----- a A b B C C .. .. .. ... .. ... wants result like for a single column col1 ------ a,b,c,........n of data and another is col1 ------- A B C D ........ a b b d ........
please explain.. DB architecture ...
How to call a sub procedure?