Indexing

Indexing

by Joshua Caleb -
Number of replies: 0

Index is a way for people to look up data quickly and more efficiently. It helps for establishing shortcuts for queries and has various tags so that when the data is observed it can be more efficiency checking the piece of data itself.  The other cool thing about indexing is that it has access times, access types, insertion of time, deletion time, and overhead time. There are also two methods for storing data and they would be sequential file organization and hash file organizations, and both have very different functions. The last thing is SQL indexes are formed by values in columns and by using create index a table or a column can be created in any table.