Interested to Buy Any Domain ? << Click Here >> for more details...
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 the purpose of reports in a database?
How to use events with zebedee, ssh or stunnel?
What are five main functions of a database administrator?
What is database partition key?
describe and contrast a trigger and a procedure.
what are the different integrity rules present in the dbms?
What do you understand by sub-queries in sql?
Define database.
Define RDBMS.
What are the four types of database?
What is the database approach?
What are the various kinds of interactions catered by dbms?
Why is the use of dbms recommended? Explain by listing some of its major advantages.
Explain about the properties of cursors?
What is the difference between indexes,views,synonyms?
