Top "Clustered-index" questions

A clustered index determines the physical order of data in a table.

Mysql How do you create a clustered index?

I'm reading all about how clustered indexes work, and think they would be beneficial to my app. I understand that …

mysql sql clustered-index
How to change the primary key to be non-clustered?

Part-time reluctant DBA here. I want to change an existing primary key index from clustered to non-clustered. And the syntax …

sql sql-server-2005 clustered-index alter
Clustered index on two columns

I've a many-to-many table, let's say: PersonJob(personId,jobId) with clustered index (personId,jobId). The question is: If somewhere in …

sql-server indexing clustered-index
SQL Server heap v.s. clustered index

I am using SQL Server 2008. I know if a table has no clustered index, then it is called heap, or …

sql-server sql-server-2008 heap clustered-index
SQL Server: Clustered index on datetime, ASC or DESC

If I have an SQL Server table with a clustered index on a datetime field, that is set to DateTime.…

sql-server clustered-index
Clustered Indexes without Primary key

A clustered index stores the actual data rows at the leaf level of the index. Returning to the example above, …

sql-server sql-server-2008 sql-server-2005 clustered-index
Should I get rid of clustered indexes on Guid columns

I am working on a database that usually uses GUIDs as primary keys. By default SQL Server places a clustered …

sql-server guid clustered-index
Clustered vs NonClustered Primary Key

begin transaction; create table person_id(person_id integer primary key); insert into person_id values(1); ... snip ... insert into person_…

performance sqlite clustered-index
Best way to change clustered index (PK) in SQL 2005

I have a table which has a clustered index on two columns - the primary key for the table. It …

sql sql-server-2005 indexing primary-key clustered-index
SQL Server query to find clustered indexes

Is it possible to write a query that returns all tables that have clustered indexes that are not based on …

sql-server tsql identity clustered-index