How many different types of indexes we have in oracle?
Answer Posted / satya krishna
B-TREE INDEX, BITMAP INDEX, REVERSE INDEX, FUNCTION-BASED INDEX, ASCENDING & DESCENDING INDEX, Cluster indexes, bitmap join indexes, text indexes, Hash cluster indexes, DOMAIN INDEXES.
Indexes are logically and physically independent of the data in the associated table.
ONCE AFTER CREATING THE INDEX ORACLE WILL AUTOMATICALLY HANDLE IT LATER.
Is This Answer Correct ? | 12 Yes | 1 No |
Post New Answer View All Answers
Explain the use of file option in exp command.
How to add a new column to an existing table in oracle?
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?
What is primefaces used for?
Can we save images in a database and if yes, how?
Can we commit inside a function in oracle?
In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?
What are the varoius components of physical database structure of oracle database?
What are the limitations of check constraint?
How to delete a user account in oracle?
What is save point in oracle database?
Which dictionary tables and/or views would you look at to diagnose a locking issue?
Give the various exception types.
How much memory your 10g xe server is using?
hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.