Viewing 4 posts - 31 through 34 (of 34 total)
I've tried a number of different one. Here's what is currently being used
CREATE CLUSTERED INDEX [IX_EffectiveItems] ON [dbo].[EffectiveItems]
(
[LOW] ASC,
[HIGH] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF,...
April 2, 2010 at 4:35 pm
Here's the plan in xml form
<?xml version="1.0" encoding="utf-16"?>
<ShowPlanXML xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" Version="1.0" Build="9.00.3042.00" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan">
<BatchSequence>
<Batch>
<Statements>
...
April 2, 2010 at 4:31 pm
The 982827279 is just an example. The value changes and can be anywhere between 72 and 994039999
April 2, 2010 at 4:19 pm
Viewing 4 posts - 31 through 34 (of 34 total)