Questions about clustered-index
Read more about clustered-index
python (65.2k questions)
javascript (44.3k questions)
reactjs (22.7k questions)
java (20.8k questions)
c# (17.4k questions)
html (16.3k questions)
r (13.7k questions)
android (13k questions)
If primary key is clustered index in a table then the other columns are eg any unique column is a table is non clustered?
CREATE TABLE people(
personID int,
FirstName VARCHAR(255),
LastNanme VARCHAR(255),
Address VARCHAR(255),
City VARCHAR(255)
PRIMARY KEY (PERSONID)
);
Saket khatavkar
Votes: 0
Answers: 1
Plot number of tickets opened and closed by month in R
I have a list of tickets and I would to create a graph to show how many opened and closed by month.
Every ticket item has 2 data points: opened_at date and closed_at date. I want to create a clustered...
Marcelo Bastos
Votes: 0
Answers: 0
Unique clustered index vs primary key
I have a table with composite primary key of 7 fields, but table is allowing duplicate entries with primary key. Later I noticed it also has Unique clustered index with 10 fields including 7 of primar...
Ashish Dubey
Votes: 0
Answers: 1
When we create a clustered index does it takes extra space?
I am asking this question with repect to mysql database.I read that clustered index orders the table based on primary key or columns that we provide for making clustered index, where as in non cluster...
PING
Votes: 0
Answers: 2