covering index

How efficient is your covered index?

by Simon Liew

SQLServerCentral.com

covering index

Article

Observing an index seek utilizing a composite index within SQL execution plan might be more than meets the eye – you should look again.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

4.83 (111)

Log in or register to rate

You rated this post out of 5. Change rating

2015-10-09 (first published: 2013-08-12)

14,449 reads

Discuss

Blogs

AI Step 1

By Vinay Thakur

As this is an Artificial Intelligence (AI) World, things are changing. We can see that...

Beginner’s Guide: Building a Dockerized Todo App with React, Chakra UI, and Rust for Backend

By Ige Adetokunbo Temitayo

In a containerized app, React and Chakra UI provide a robust and accessible user...

A New Word: Nachlophobia

nachlophobia – n. the fear that your deepest connections with people are ultimately pretty...

Read the latest Blogs

Forums

Call dynamic sql storedprocedure from SSIS execute sql task

hi, I have a table called Rules Create table Rules ( Id int ,...

Migrating database with many orphan users.

I am currently upgrading a very old database running SQL Server 2008 to SQL...

Active and Active Cluster

Hi Team, I am planning to apply security updates for SQL Server 2016 on...

Visit the forum

Question of the Day

The Funny SELECTs

What is returned from this query?

SELECT
  ( SELECT COUNT (*) FROM Sales.SalesOrderHeader AS soh
    WHERE soh.OrderDate > '01/01/2011' AND soh.OrderDate < '01/01/2012') AS OrdersIn2000
, ( SELECT COUNT (*) FROM Sales.SalesOrderHeader AS soh
    WHERE soh.OrderDate > '01/01/2012' AND soh.OrderDate < '01/01/2013') AS OrdersIn2001
, ( SELECT COUNT (*) FROM Sales.SalesOrderHeader AS soh
    WHERE soh.OrderDate > '01/01/2013' AND soh.OrderDate < '01/01/2014') AS OrdersIn2002;

See possible answers