Indexes in oracle ?

Answers were Sorted based on User's Feedback



Indexes in oracle ?..

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

Indexes in oracle ?..

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

Indexes in oracle ?..

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

Post New Answer

More Oracle General Interview Questions

HOW TO CONVERT ORACLE TABLE DATA (RECORDS)INTO EXCEL SHEEET?

3 Answers  


What is Parallel Server ?

3 Answers  


What is Segment Advisor in Oracle?

0 Answers   MCN Solutions,


how to produce numbers from 1 to 10 using dual table

4 Answers   Genpact,


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.

3 Answers   Wipro,






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.

0 Answers  


How do I uninstall oracle client from windows?

0 Answers  


what is data abstraction

3 Answers   Semantic Space,


In Oracle 9i what does "i" Stands for?

36 Answers   MBT,


What is data block in Oracle?

0 Answers   MCN Solutions,


How to apply filtering criteria at group level in oracle?

0 Answers  


what are indexes..how many types of index's are there and what are they?

7 Answers   Green Info Solutions, TCS,


Categories
  • Oracle General Interview Questions Oracle General (1789)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)