Answer Posted / 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 |
Post New Answer View All Answers
What is database or database management systems (dbms)? And what's the difference between file and database? Can files qualify as a database?
How can you perform pattern matching in sql?
Explain the term entity set in dbms?
What is the difference between horizontal and vertical partitioning?
Differentiate between nested loop, hash loop and merge join.
Enlist various types of interactions created by dbms?
What you know in mapping of erd to dfd?
How does notification services work?
What is the difference between hashed file stage and sequential file stage in relates to datastage server?
Is sql a rdbms?
Is database a storage?
What is an artificial (derived) primary key? When should it be used?
Can I use google sheets as a database?
What is Data Redundancy and Consistency ?
What are dml and ddl statements?
