-- Primary Key Index 
-- automatically creates a unique index on the column
-- Depends on the storage engine

-- Clustered Index (primary index )
-- Stores the actual row data in the same structure as the index 
-- Can be only one clustered index per table because the data rows themselves are stored
-- in order of the index 
-- Uses primary key as the clustered index by default. 

-- Nonclustered index - stores a seperate structure with pointers to the actual data rows 
-- Can have multiple non-clustered indexes on a table 

-- Full-Text index -- Designed for searching natural language text