Answer / 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);

There is one report running and a user wants to know whether data is from detail table or summary table. what is your approach?

1 Answers  

---

What is a Set?

1 Answers  

---

WHAT IS SYNCHRONIZATION IN BOXI?

2 Answers   HCL,

---

CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN

1 Answers   ASD Lab, Wipro,

---

what is dashboards? what is metrics?

7 Answers   TCS,

---

suppose case1:a person buy a car case2: rent a car which is context & which is alias? why?

2 Answers   IBM,

---

How to make alternative rows red and green in WebI Report?

3 Answers   Accenture, Mphasis,

---

Can anybody tell me about issues faced while creating universe. thanks in advance

1 Answers   Accenture,

---

How to display the top 5 records along with the additional records,plus their sub and grand totals to be display in the same block.

1 Answers   Oracle,

---

What is the short cut join?

2 Answers   Wipro,

---

How can you check the universe?

3 Answers  

---

IF VIEW IS FASTER THAN DERIVED TABLE WHY WE ARE USING DERIVED TABLE IN BUSINESS OBJECTS?

1 Answers   Accenture,

---