How many different types of indexes we have in oracle?
Answer Posted / swapna
We have mainly two different indexes .
Implicit index and Explicit index.
Explicit indexes are again of many types like
simple index,unique index,Bitmap index,Functional
index,Organisational index,cluster index.
| Is This Answer Correct ? | 179 Yes | 64 No |
Post New Answer View All Answers
Can we create database in oracle using command line ?
How to find the duplicate rows count from employees table in oracle?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
what is port in oracle? how is it related to database application.
What are the differences between blob and clob in oracle?
What do you know about normalization? Explain in detail?
query optmization techniques and quwry analyser+projects+ppts
Why do we need oracle client?
What is oracle latest version?
Explain joins in oracle?
Which is faster join or subquery in oracle?
Explain the use of ignore option in imp command.
Explain oracle left join with an example?
Explain the use of rows option in exp command.
What is analyze command used for?