Indexes In DBMS Explain With Examples, Why Index Is Done In DBMS, What Is Index
Why Index Is Required:
When the user fires a SELECT statement to search for a particular record, the oracle server must first locate the table on the hard disk.
The oracle server then performs a sequential search to locate records that match user-defined criteria.
Indexing a table is an ‘access strategy’, that is, a way to search records in the table.
Indexes are essential to improve the speed with which the records can be located and retrieved from a table
Indexes In DBMS
An index is an ordered list of the contents of a column of a table.
An index can be created on one or more columns.
Indexing involves forming a two dimensional matrix completely independent of the table on which the index is being created.
0 comments:
Post a Comment
Thanks For Your Comment. We Get Back To You As Soon As Possible.