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
How to unzip a file in ssis?
What are the types of database servers?
Explain the hierarchical database?
Define stored procedures.
What is indexing in database with example?
What is entity relationship diagram?
When should you consider denormalization?
What is the role of database management system?
Is sql is a dbms?
What is data redundancy in dbms?
There are 100 datafiles, numbered from 1 to 100. File number 10 is deleted and it has 500 MB of data. The database is working in archive log mode. How can be the database recovered ? While doing recovery the archive logs applied are from nos 1 to 100, but 50 gets corrupted. What do we do? Can we proceed further? If so how?
Explain the role of metadata for the three-layer architecture.
What are the different type of relationships in the dbms?
What are records and fields in a database?
What do you mean by transparent dbms?
