What is Indexing? how did u implement indexing?
- 1 Answers
- 2628 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / Vivek Misra
Indexing is a database management technique used to optimize data retrieval by creating an auxiliary structure (index) that stores the location or key values of specific data within the database. By using indexes, the database engine can quickly locate and retrieve records without having to scan the entire table.
There are different types of indexes, such as B-tree indexes, hash indexes, and bitmap indexes, each with their own advantages and limitations. The choice of index type depends on factors like query patterns, data distribution, and performance requirements.
Implementing an index in a database can be done through SQL commands or using a graphical user interface provided by the database management system. For example, to create an index on a specific column in MySQL, you can use the following command:
CREATE INDEX index_name ON table_name (column_name);
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain about a tricky situation for which you found a very simple solution?
What is the difference between business requirement document and use case document.
i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?
I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!
How would you format some text using css to be verdana and bold?
how many reports have u created ? explain a few.
what is document design in boxi,have u participate in that
explain in detail about type 3?
How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?
What is aggregate table and aggregate fact table ... Any examples of both?
Explain what is aggregate table and aggregate fact table ... Any examples of both?
Explain about a time when you discovered a more efficient way to do a work task?
What are the data types present in bo? What happens if we implement view in the designer and report?
What sort of existing documents should business analysts refer to when starting on a new project?
