What is an Index?

An index is a data structure, a special data structure designed to improve the speed of data retrieval. An index on a file speeds up selections on the search key fields for the index. 


 CLUSTERED INDEX Clustered index is a type of index which sorts the data rows in the table on their key values. Clustered index exists as sorted row on disk. Clustered index re-orders the table record. Clustered index contains record in the leaf level of the B-tree. NON-CLUSTERED INDEX A Non-clustered index stores the data at one location and indices at another location. The index contains pointers to the location of that data. Non-clustered index is like the index in the back of a chemistry text book. The chemistry text book has some natural order to it: Chapter 1: Matter Chapter 2: Elements Chapter 3: Compounds DENSE INDEX In a dense index, a record is created for every search key valued in the database. This helps you to search faster but needs more space to store index records. In this Indexing, method records contain search key value and points to the real record on the disk. key columns are stored. SPARSE INDEX It is an index record that appears for only some of the values in the file. Sparse Index helps you to resolve the issues of dense Indexing. Primary and Secondary Indexes An index on a set of fields that includes the primary key is called a primary index. Primary Index requires the rows in data blocks to be ordered on the index key. An index that is not a primary index is called a secondary index. They can be in any order.

Comments

Post a Comment

Popular posts from this blog

JSS1 COMPUTER STUDIES FINAL EXAM QUESTIONS

Image
  3.Term Final Exam Question    1.     What does ICT stands for? A.     Information and Communication Technology B.     Instant Command Transmission C.     Internet Community Technology D.    Information Continuity Transfer   2.     One of the following is a disadvantage of ICT. A.     Expensive setup B.     Accommodation C.     Productivity D.    Independent   3.     All are laboratory rules and regulations except ___________                             A.     Maintaining dust-free environment. B.     Do not move any equipment from its original position. C.     Do not load or remove any software from the system. D.    Do not attempt to repair laboratory equipment.   4.     One of the following best describe ICT. A.     The communication between two people B.     The use of electronic devices and other electronic communication means to manage and process information effectively. C.     Intersection of row and a column D.    it is a place where we buy our goods   5.     Ethics means wha
Read more

JSS3 COMPUTER STUDIES PAPER III PRACTICAL

Image
  PAPER III (PRACTICAL)   1.   Use Microsoft Word to prepare your Curriculum Vitae (CV) showing the following information ·         Name, Date of birth ,Place of birth, Local Government Area, State of Origin , Nationality, Primary School Attended ,Next of Kin, Next of kin GSM Number ,One Referee (name only)   Note: i.  Items a to j should be bold and information provided should be italicized. ii. The heading CURRICULUM VITAE should be in upper case, bold and underlined   2.   Use Corel Draw or MS Publisher to design a simple letter head paper for your father or any relation’s businesses organization, showing at following information: ·         Use any form of LOGO , Company Name, Address of the location of the company , Our ref and your ref , Telephone or GSM number ·         Use any suitable line to demarcate the heading and body of the paper   3.   Use Microsoft Excel to prepare the table. Do not forget to use formula for average and sum.    
Read more