What is an index and types of indexes. How many number of
indexes can be used per table ?
Answer Posted / guest
Index is a method used for faster retrieval of
records.different types of indexes are
1.primary key index
2.unique index
3.bitmap index
4.hash index
5.function based index
6.B-tree index(default index created) on table.
7.Virtual index(which do not show entry in DBA_segment).
| Is This Answer Correct ? | 128 Yes | 35 No |
Post New Answer View All Answers
What is foreign key sql?
Does sql between include endpoints?
how many sql ddl commands are supported by 'mysql'? : Sql dba
How many columns should be in an index?
Can pl sql procedure have a return statement?
What are the different types of dbms?
What is a crud api?
What are different categories of sql commands?
What is information schema in sql?
Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence. flat file product Prono,pro_name, 1, 20 watt tube light 2, 30 watt tube light & target should be like 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights. 104, 20 watt tube light 105, 30 watt tube light thks reg suvarna joshi suvarnaatsuvarna@rediffmail.com
What is the usage of distinct keyword?
What are the different type of joins in sql?
how to delete an existing column in a table? : Sql dba
What is type and rowtype in pl sql?
Which one is better subquery or joins?