Search Results
| Search type | Search syntax |
|---|---|
| Tags | [tag] |
| Exact | "words here" |
| Author |
user:1234 user:me (yours) |
| Score |
score:3 (3+) score:0 (none) |
| Answers |
answers:3 (3+) answers:0 (none) isaccepted:yes hasaccepted:no inquestion:1234 |
| Views | views:250 |
| Code | code:"if (foo != bar)" |
| Sections |
title:apples body:"apples oranges" |
| URL | url:"*.example.com" |
| Saves | in:saves |
| Status |
closed:yes duplicate:no migrated:no wiki:no |
| Types |
is:question is:answer |
| Exclude |
-[tag] -apples |
| For more details on advanced search visit our help page | |
Results tagged with index
Search options questions only
not deleted
user 6268
A database structure that can improve the speed of queries at the cost of disk space and slower inserts/updates. It stores a copy of one or more columns sorted but structures the data differently to allow faster access.
3
votes
1
answer
2k
views
Error when creating an index in SQL Server 2012
I'm trying to create the following index on our test environment (SQL Server 2012):
CREATE NONCLUSTERED INDEX [iTransaction-OriginatingTransaction] ON [dbo]. … If I run the same create index statement on our live database (SQL Server 2005) then it works without any errors.
Why can't I create this index on SQL Server 2012? …
- 3,272
4
votes
2
answers
1k
views
Performance impact of having gaps in Identity Column in SQL Server 2005
We have a number of tables in our database with an identity column as the primary key & clustered index. … Is there any impact to the performance of the clustered index on these tables as a result of these "missing" identities? …
- 3,272
7
votes
4
answers
703
views
Using a filtered index when setting a variable
I know from other questions and posts that when SQL compiles a query plan it can only use a filtered index if the filtered index is guaranteed to be able to be used every time the query runs. … Doing some testing, I found that this query can use a filtered index (note, I'm forcing the index just to prove a point):
SELECT MAX(table1.SomeDateField)
FROM dbo.table1 WITH(INDEX(MyFilteredIndex …
- 3,272
8
votes
2
answers
3k
views
Any advantage of having a second index with included columns on a primary key?
ColN VARCHAR(50)
....
another 10 more columns
In addition to the standard primary key clustered index on Col1, we also have the following index:
create nonclustered index [iTable-Col1] ON [dbo]. … This index does get used as it is the smallest index that contains all of the data required to satisfy the query.
My question is, does this index add any benefit to SQL Server? …
- 3,272
70
votes
4
answers
59k
views
Index Seek vs Index Scan
Looking at an execution plan of a slow running query and I noticed that some of the nodes are index seek and some of them are index scan. … What is the difference between and index seek and an index scan?
Which performs better?
How does SQL choose one over the other? …
- 3,272