top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

What is indexing and what are the different kinds of indexing ?

+3 votes
1,175 views
What is indexing and what are the different kinds of indexing ?
posted Feb 1, 2014 by anonymous

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

2 Answers

0 votes

Indexing is a technique for determining how quickly specific data can be found.
Types:
1. Binary search style indexing
2. B-Tree indexing
3. Inverted list indexing
4. Memory resident table
5. Table indexing

answer Feb 2, 2014 by Vikas Upadhyay
0 votes

Indexing is a way of sorting a number of records on multiple fields. Creating an index on a field in a table creates another data structure which holds the field value, and pointer to the record it relates to. This index structure is then sorted, allowing Binary Searches to be performed on it.

clustered, multi-dimensional clustered, unclustered, unique,
non-unique, b-tree, hash, GiST, GIN, full-text, bitmap,
partitioned, function-based.

For More Info.

http://www.msdn.microsoft.com/en-us/library/ms175049(v=sql.110).aspx

http://www-01.ibm.com/support/knowledgecenter/SSEPGG_9.5.0/com.ibm.db2.luw.admin.dbobj.doc/doc/c0020180.html?lang=en

answer Aug 16, 2014 by anonymous
...