Post reply

Does running multiple SQL queries in the same SP cause latency ?

  • May 15, 2014 at 5:44 am

    #1713805

    isuckatsql (5/15/2014)

    "By the way, just we're clear, dbo.cb is an indexed view? What's the key value on?"

    dbo.cb is a Table not am Indexed View.

    The primary key is ID.

    Thanks

    Then where are the indexed views? I'm confused.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • May 15, 2014 at 8:18 am

    #1713867

    Grant Fritchey (5/15/2014)

    isuckatsql (5/15/2014)

    "By the way, just we're clear, dbo.cb is an indexed view? What's the key value on?"

    dbo.cb is a Table not am Indexed View.

    The primary key is ID.

    Thanks

    Then where are the indexed views? I'm confused.

    Script table CB

    "CREATE TABLE [dbo].[CB]("

    Script Indexed Views

    "CREATE VIEW [dbo].[degreetype] WITH SCHEMABINDING AS

    SELECT degreerequired, COUNT_big(*) as cnt

    FROM [DBO].CB

    GROUP BY DegreeRequired"

    "CREATE VIEW [dbo].[emptype] WITH SCHEMABINDING AS

    SELECT employmenttype, COUNT_big(*) as cnt

    FROM [DBO].CB

    GROUP BY employmenttype"

    "CREATE VIEW [dbo].[statetype] WITH SCHEMABINDING AS

    SELECT locationstate, COUNT_big(*) as cnt

    FROM [DBO].CB

    GROUP BY locationstate"

    Apologies for the confusion.

Viewing 2 posts - 16 through 16 (of 16 total)

You must be logged in to reply to this topic. Login to reply