Question : I have a query which has an optional where condition on column classID(not unique). This same classID is […]
Tag: clustered-index
Difference between Clustered Index and Unique Clustered Index? [closed]
Question : Closed. This question is off-topic. It is not currently accepting answers. Want to improve this question? Update the […]
Lookup table for a one-to-many relationship
Question : I have a tickets table with an id that I need to associate to a lookup table where […]
When all you indexes have included all the other columns, do you still have the penalty for a wide clustered index?
Question : So I hear sometimes that I should not use a clustered index on a wide column, mainly because […]
How to speed up query on table with millions of rows
Question : The Issue: I’m working on a big table that consists about 37mln rows. Data include measurements of many […]
Avoiding a sort on an already clustered index for group by
Question : On a table T with two fields, pid and did, the following query results in a seq. scan […]
Are page numbers of a book a good analogy for a clustered index? [closed]
Question : Closed. This question is off-topic. It is not currently accepting answers. This question does not appear to belong […]
Table design for efficiently retrieving “most recent row” per FK’d item whose PK is a GUID
Question : Database is SQLAzure I’ve a recent requirement to store incremental updates in status against an Order item, whose […]
SQL Server: Clustered index, sorting and pagination
Question : In my application, several times I have to show results that are paginated and sorted by some field. […]
How to efficiently create a new PRIMARY KEY CLUSTERED definition online
Question : Given a table with a PRIMARY KEY definition (acting as the clustered index), I want to efficiently change […]