开发者

How would I create an index on this temp table?

I am trying to speed up a query and I think I am confused about indexes. How, and what index would I add to this table. The ID is Unique, would this be a primary index?

CREATE TABLE #OSP
    (
        [Id] UniqueIdentifier,
        [YearMonth] int,
        [Expe开发者_Go百科nditure] decimal (7,2),
        [Permit] decimal (7,2)
    );


You can specify the primary key in your create table statement.

CREATE TABLE #OSP
    (
        [Id] UniqueIdentifier primary key,
        [YearMonth] int,
        [Expenditure] decimal (7,2),
        [Permit] decimal (7,2)
    );


If you're joining on id then creating an index on that would help.

I think this would work:

CREATE TABLE #OSP
    (
        [Id] UniqueIdentifier,
        [YearMonth] int,
        [Expenditure] decimal (7,2),
        [Permit] decimal (7,2)
    );


CREATE UNIQUE CLUSTERED INDEX [idx_id] ON #Osp ([Id] ASC)
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜