By tag: Index
0
kicks
Interesting Observation - Effect of Clustered Index over Nonclustered
Query optimization is one art which is difficult to master. Just like any other art this requires creativity and imagination as well understanding of subject matter. Let us look at interesting observation which I came across.
In our example we have one query which is not using any index. On the s...
0
kicks
Lucene document indexing in .Net C#
Sample .Net C-sharp code for creating Lucene Index for given SQL Server Stored Procedure
0
kicks
Efficient Compound Index Usage
Discusses the importance of columns used in a where clause with a compound index. Shows how the order of your columns within a compound index can impact performance. Gives tips on how to properly order your columns within the compound index.
0
kicks
Back To Basics: What is a Clustered and a Non-Clustered index
An explanation of Clustered and Non-Clustered index using a library analogy (plus a visual prop :))
0
kicks
SQL Server 2005: Hypothetical index - a what?!?!
Yes there is such a thing.
It's an index created by the DTA (Database Tuning Advisor)
0
kicks
IndexedDictionary. Access a dictionary using item index
.NET Dictionary object can hold a collection of keys and values. It allows you to iterate through these values using enumeration and you can also retrieve a value by using it's associated key.
But what if you want to create a collection of items and access them both using their associated key or nu...