MCQs Test!! VB Basic Test !! Essentials of VB !! Creating User Services !! function !! Anatomy !! GK March-2019 !! DATA TYPES IN JAVA !! Classes ,Constructor ,Methods,Inheritance !! Ecology-I !! Biology 2019 !! Gk april 2019 !! Biology (living world) !! Plant anatomy !! CELL STRUCTURES AND FUNCTION !! General biology !! Human physiology !! Data structure !! Ecology-II !! GK TEST !! Reproduction in plants !! Human reproduction !! The ABC of C !! Operating system set1 !! Operating system set2 !! Gk and current affairs !! Animal kingdom !! Number system !! Animal kingdom-II !! Gk TEST-III !! Number series !! Microorganisms !! Interview question in c !! Time and Work !! Percentage !! General history !! Average !! Cells !! Locomotion and Movement !! paging !! Bacteriology !! Page replacement policy !! Secondary memory and Disk scheduling !! Introduction of Nervous System and neurons !! Plant harmones !! Transport and Mineral Nutrition in Plants !! Neurotransmitters !! Modern Indian History !! Photosynthesis in Plants !! Modern Indian History-II !! Plant respiration !! Environment & Biodiversity !! Environment & Biodiversity - II !! Algae, Bryophytes, Pteridophytes !! Area !! Cricket !! Days of the Year (India and the World) !! Plant Pathology - I !! Indian Transport System !! Plant Pathology - II !! Aptitude !! Biology !! Botany !! C language !! Computer Science !! Core Java !! Gate !! GK !! Mysql !! Operating system !! Physics !! VB-Visual Basic !! Zoology

DATABASE & SQL/PLSQL

How to Create an INDEX
Previous Home Next
  1. Identify the tables on which the index will be created.
  2. Identify the attribute on which the index will be created.
  3. Identify the type of index will be created.
  4. Identify the name of the index to be created. (Prefix an 'idx' to the name of the index to help in locating/identifying the index.)
  5. Create the index.

Syntax:

CREATE  [UNIQUE] [CLUSTERED or UNCLUSTERED]  INDEX  index_name
ON  table_name (column_name...)

where, UNIQUE creates an index in which each row should contain a different index value.

CLUSTERED specifies a clustered index in which data is sorted on the index attribute.

NONCLUSTERED specifies a nonclustered index that organizes data only logically. the data is not sorted physically.

index_name specifies the name of the index.

The index name should be unique in the table, but it may not be unique within a database.

table_name specifies the name of table and column_name is the name of columns on which the index would be created.

CREATE CLUSTERED INDEX  ad_name
ON employee (emp_id)

 

How to Verify that Indexes has been created

Syntax:

sp_helpindex  table_name

CREATE NONCLUSTERED INDEX  INemp_name
ON  employee (emp_name)

sp_helpindex  employee

output

Previous Home Next