WHAT IS INDEXING?
Answers were Sorted based on User's Feedback
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.
Is This Answer Correct ? | 6 Yes | 0 No |
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.
Is This Answer Correct ? | 1 Yes | 1 No |
Answer / pppandu
It Is One Of The Database Object,Which Automatically
Created While Creating The Primary Keys Those Gives More
Performance
Is This Answer Correct ? | 1 Yes | 4 No |
How to lock records in a table?
What is buffer manager?
What is the difference between delete and truncate command in dbms?
Explain the difference between a dynamic and materialized view.
Who proposed the relational model?
How is data stored in a database?
What do you mean by conflict serializability in dbms?
Mention the differences between union and union all
What is acid property in dbms?
What is a clause in terms of sql?
Which is best database?
5) Which acid property will effect when we use commit in trigger?