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 executive plan?
All questions related to Control m monitoring tool
What is sorting in dbms?
What are the benefits of database?
List few ways to code transactions in an efficient manner?
What are reports in a database?
1.If we have a Salary coloumn in Staff entity with this description the salary must be monetary and >=$35450.00, how we can write it in into schemain SQL? 2. If we have Weight and Marks in Assessment entity and the Weight has the description of this it must be Non-zero percentage. And also the Marks attribute stores the maximum possible raw mark for assessment (e.g., 30), while Weight stores of the weight of this assessment for the paper as a whole (e.g., 10%). If Marks is not specified, then Weight is used for both. How we can convert this into schema in SQL????
What are the different stages in 'data warehousing'?
What is oracle block? Can two oracle blocks have the same address?
What do you understand by correlated subqueries in dbms?
What is pcbs (program communication blocks)?
What is the purpose of a database table?
What do databases contain?
What is tuple and attribute?
What are the features of a database management system?
