Answer / savithri

A database index is a data structure that improves the
speed of operations in a table. Indices can be created
using one or more columns, providing the basis for both
rapid random lookups and efficient ordering of access to
records.

Answer / sunny sarin

Indexing is creating an index for a table in the database to
fasten the speed of retrieving the results and for better
performance and efficiency.
Normally,indexes are of 2 types
unique
non-unique

unique index is created implicitly by the server whenever
any primary or foreign key constraint is given to any
column/s in the table.

we can also create a non unique index for any column in the
table.

indexes are stored on a different segment than the
table,this reduces contention on the table

indexes should not be created for that columns for which the
value in the column varies a lot.

indexes should also not be created on the columns on which
high level of DML's and DDL's are performed.

Answer / pppandu

It Is One Of The Database Object,Which Automatically
Created While Creating The Primary Keys Those Gives More
Performance

What is database optimization?

0 Answers  

---

Describe the difference between data and database administration.

0 Answers  

---

What is oracle block?

0 Answers  

---

What is field record and table in database?

0 Answers  

---

What are the main differences between primary key and unique key?

0 Answers  

---

What is first normal form in dbms?

0 Answers  

---

Where is data stored in database?

0 Answers  

---

Give the cobol definition of a varchar field 177 when can an insert of a new primary key value threaten referential integrity?

0 Answers  

---

What is actional flow mapping?

0 Answers  

---

What is a foreign key constraint?

0 Answers  

---

What are the functions of database management system?

0 Answers  

---

What is Dedicated server configuration ?

2 Answers  

---