Posted On: Feb 22, 2018
Many Information is stored in a database and locating and retrieving the information will be difficult without an index. A database index is, therefore, that which makes searching and retrieving specific data or information from a database easier and faster. A database index can be likened to an old recipe box that has dividers. Through the recipe box, you are directed to various categories such as cereals, legumes, salad, soups, and vegetables. Instead of searching through all the numerous categories, a database index takes you directly to what you are looking for. The science catalog in an online library is another example of a database index.
Never Miss an Articles from us.
There are various kinds of interactions supported by DBMS like- Data definition Update Retrieval Administration..