Search
 
SCRIPT & CODE EXAMPLE
 

SQL

what is the difference between clustered and non-clustered index in sql server

Clustered Index:
1.Its created on primary key 
2.Store data physically according to the order
3.Only one clustered index can be there in a table
4.No extra space is required to store logical structure 
5.Data retrieval  is faster than non-cluster index 

Non-Clustered Index:
1.It can be created on any key 
2.It don’t impact the order 
3.There can be any number of non-clustered indexes in a table
4.Extra space is required to store logical structure 
5.Data update is faster than clustered index
Comment

PREVIOUS NEXT
Code Example
Sql :: sql server last 2 days 
Sql :: mysqlclient error 
Sql :: mysql order by two columns priority 
Sql :: how to set a column as unique in sql server 
Sql :: SQL query to verify the size of the table 
Sql :: oracle select into 
Sql :: Create boolean column in MySQL with false as default value? 
Sql :: row to json in sql server 
Sql :: alternative for LIMIT sql 
Sql :: create temp table in sql 
Sql :: mysql select row with min date 
Sql :: delete data from database sqlite android 
Sql :: create table with index mysql 
Sql :: update foreign key value in mysql 
Sql :: mysql wont stop 
Sql :: how to select random rows from a table 
Sql :: sql convert datetime 
Sql :: athena create table 
Sql :: oracle current session details 
Sql :: mariadb cast to int 
Sql :: plpgsql if statement 
Sql :: count occurrences sql 
Sql :: sql oracle limit 
Sql :: sql ending with vowels 
Sql :: MySQL import data from large CSV file 
Sql :: order by ip address sql 
Sql :: sqlite select split string 
Sql :: replace tab in sql 
Sql :: how to casting data types in postgresql 
Sql :: sql rename table 
ADD CONTENT
Topic
Content
Source link
Name
9+7 =