What is an index and types of indexes. How many number of
indexes can be used per table ?
- 12 Answers
- 79256 Views
- Accenture, BirlaSoft, Cognizant, CTS, Symphony, I also Faced
- E-Mail Answers
Answer Posted / naresh
index's are used to retrive the data with in the required
time.there are two types of indexes we have
1.bitmap index
2.B-tree index
| Is This Answer Correct ? | 16 Yes | 17 No |
Post New Answer View All Answers
Where the sql database files are stored?
What is the difference between left outer join and left join?
1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins
Can a trigger call a stored procedure?
Can we write dml inside a function in sql server?
What is procedure in pl sql?
What is difference sql and mysql?
How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?
how can we destroy the cookie? : Sql dba
How do I run a query in pl sql developer?
what is collation? : Sql dba
What is the plv (pl/vision) package offers?
How do you identify a primary key?
What is trigger in pl sql?
Why left join is used in sql?
