Forum Replies Created

Viewing 4 posts - 31 through 34 (of 34 total)

  • RE: Improve Between performance

    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,...

  • RE: Improve Between performance

    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>

    ...

  • RE: Improve Between performance

    The 982827279 is just an example. The value changes and can be anywhere between 72 and 994039999

  • RE: Improve Between performance

    OK, here it is

    StmtText ...

Viewing 4 posts - 31 through 34 (of 34 total)