Interested to Buy Any Domain ? << Click Here >> for more details...
How many different types of indexes we have in oracle?
- 24 Answers
- 193463 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answer Posted / vipul.solanki
Index is use for the performance to retrieve data from table.
1 . index automatically created when create PK or UK
2 . Explicitly create index
there is three type of index
1.unique index
2.cluster index
3.non-cluster index
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What is set operator oracle?
How to insert multiple rows with one insert statement in oracle?
What are a cluster and non-cluster index?
State and explain about oracle instance?
How can I see all tables in oracle?
1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
What happens to the current transaction if a ddl statement is executed?
Explain the difference between sql and oracle?
Explain joins in oracle?
Differentiate between post-database commit and post-form commit?
How much memory your 10g xe server is using?
What do you understand by a database object?
What is the difference between online and offline backups?
What is raw datatype?
How to save query output to a local file?
