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
Define entity, entity type, and entity set.
What is field in database give an example?
When would you use a database?
What is trigger in dbms?
What is the purpose of reports in a database?
What is dbms introduction?
What is primary key in dbms?
Is filemaker pro a relational database?
Who is the founder of database?
What is a database in computer?
What is inner join in database?
What are the steps in creating a database?
Define cursor.
Differentiate nested loop, hash join and merge join.
What is database join?
