How many different types of indexes we have in oracle?
Answer Posted / nimisha
Implicit index and Explicit index.
| Is This Answer Correct ? | 63 Yes | 29 No |
Post New Answer View All Answers
what is the difference between data migration and production migration.
What is a system tablespace?
Can the query output be sorted by multiple columns in oracle?
What are the various types of snapshots ?
What are the ways tablespaces can be managed and how do they differ?
How to write a query with an inner join in oracle?
Which is better Oracle or MS SQL? Why?
How to insert multiple rows with one insert statement in oracle?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
How to work with data objects interactively?
i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?
What is PL/SQL ?
Explain oracle left join with an example?
How to create a table index?
how do u setup a replication site?