Read this for a more simple example
From: we7313 (we7313_at_discussions.microsoft.com)
Date: 12/23/04
- Previous message: we7313: "Execution plan question"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 23 Dec 2004 13:19:05 -0800
CREATE PROCEDURE dbo.will
(
@a int,
@b int
)
AS
SELECT * from price_view where keydate between @a and @b
GO
Keydate is the The first field in the clustered key
The table is shown in the previous post.
-- will
- Previous message: we7313: "Execution plan question"
- Messages sorted by: [ date ] [ thread ]
