The nonclustered-index tag has no wiki summary.
2
votes
2answers
61 views
If I update a column record in a table, will indexes that do NOT have this column in it be affected?
In terms of performance if I have a table like so:
CREATE TABLE [TESTDATA].[TableA](
[Col1] [nchar](5) NOT NULL,
[Col2] [nchar](2) NULL,
[Col3] [float] NULL
CONSTRAINT [TableA_PK] PRIMARY ...
2
votes
1answer
67 views
Unique Non Clustered Column in Partitioned table
We have partitioned one of our SQL Server tables on a Clustered Index datetime column, we have a Primary key Non-clustered index column with Identity data type and this column is setup as a ...
1
vote
2answers
126 views
Clustered vs Nonclustered Index
My database currently has a primary Key/Clustered index on the ID column for each table. However, the application that connects to the database is always looking at views defined as:
SELECT * FROM ...
4
votes
1answer
67 views
Index Evaluation
I have been doing some index evalaution on a table and this is the first time I have ever looked at how well indexes are performing so and would like some advice on a certain index.
The non ...
1
vote
3answers
139 views
When to create Indexes?
I have a stored procedure that takes around 2 minutes to execute. The execution plan suggested me to create a non clustered index on a table (which is a high traffic table with millions of records in ...
1
vote
1answer
116 views
Covering Index - Include columns
I have a table :
[sch].[Parent]
(
ID Identity [INT] (PK),
Name VARCHAR(100),
Email VARCHAR(250),
Active TINYINT,
InsertedBy VARCHAR(100),
InsertedDTM DATETIME,
...
2
votes
1answer
146 views
Non-clustered Index Update not displayed in execution plan [duplicate]
Possible Duplicate:
Nonclustered Index Insert
I'm trying to work out the cost of having a nonclustered index on a particular table, but I don't see any maintenance cost in the execution ...
3
votes
2answers
261 views
Large Fact table and partitioning key dilemma
I have fairly large fact table (2 billion records, approx 120 GB). This table is not partitioned and the queries are very slow to respond. I am planning to partition the table and indexes.
The table ...
0
votes
1answer
1k views
fundamental difference between Primary/Clustered and Secondary/Non-Clustered index
Are
Primary Index and Clustered Index similar in concept
Secondary Index and Non-Clustered Index similar in concept
2
votes
1answer
139 views
Aren't two writes required to update a clustered index record
I was reading the article on indexes at simple-talk, where it is written that
If a heap has a non-clustered index on it (as the primary key), and data is inserted into the table, two writes have ...
5
votes
2answers
689 views
Should I create a nonclustered index on all searchable columns or just each column separately?
I am not sure as to properly use non-clustered indexes. The SSMS plan estimator said to add another index when the following index was on the table already.
CREATE NONCLUSTERED INDEX ...
4
votes
2answers
132 views
Need for reaching data through clustered index with a non-clustered index
I have found that when a table has both clustered and non-clustered indexes (on different columns), the leaf level non-clustered pages, instead of pointing to the data row, point to the node of the ...
4
votes
1answer
187 views
How are indexes represented in an ERD?
What do indexes look like in an Entity Relationship Diagram?
I've googled it and I'm unsure what the standard look of an index is in an ERD. And I'm talking about the crowsfoot diagram that includes ...
