WHAT IS INDEXING?
Answers were Sorted based on User's Feedback
Answer / savithri
A database index is a data structure that improves the
speed of operations in a table. Indices can be created
using one or more columns, providing the basis for both
rapid random lookups and efficient ordering of access to
records.
Is This Answer Correct ? | 6 Yes | 0 No |
Answer / 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 |
Answer / pppandu
It Is One Of The Database Object,Which Automatically
Created While Creating The Primary Keys Those Gives More
Performance
Is This Answer Correct ? | 1 Yes | 4 No |
Mention the differences between unique key and primary key
What is the easiest database to learn?
What is sql in database management system?
what are the different levels of database schema?
Is excel a database?
can Constraints cannot be exported through EXPORT command ?
2 Answers Grasim, Oracle, Suvidha,
How can I join two tables in database?
What are the applications of rdbms?
What is a database in layman terms?
8. Sort, Lookup What kind of technique (partition) is used? 9. How can you handle exceptions in job sequencer? 10. How do you apply custom conditions an exceptions (How do you trigger exceptions in job sequence?) 11. I have a job with 3 possibilities? Finish with ok…..Abort…….Warning} How do you handle these in Job sequencer 12. How do you connect both OK and Warning can we? 13. How to find which process is running currently? 14. How do you find the disk usage in UNIX? 15. How do you combine 2 sequential files having same metadata of same file names? 16. How do you implement SCD in Ds? 17. Explain the situation where you have applied? 18. How do you apply new changes to? 19. Difference between change capture and Change apply? 20. Explain Compare Stage? 21. What is Surrogate key? 22. How to solve the problem of null values?
What is a Built_in subprogram ?
What is the use of FULL option in EXP command ?