Computed Column Indexes

Question

Computed Column Indexes

Steve Jones - SSC Editor

SSC Guru

Points: 736172
More actions
November 12, 2019 at 12:00 am

#3680383

Comments posted to this topic are about the item Computed Column Indexes

Viewing 4 posts - 1 through 3 (of 3 total)

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

William Vach SSCertifiable Points: 5538 More actions · Answer 1

Steve, thanks for the question. As is, you get a syntax error because of the schema in the Create Index statement. If you remove the schema,then it works fine.

As is:

CREATE INDEX dbo.Activities_PRodOneCountThreshold

ON dbo.Activities (ProdOneCount)

WHERE CallCount > 50;

GO

Msg 102, Level 15, State 1, Line 14

Incorrect syntax near '.'.

Completion time: 2019-11-12T08:29:28.6131625-05:00

Corrected:

CREATE INDEX Activities_PRodOneCountThreshold

ON dbo.Activities (ProdOneCount)

WHERE CallCount > 50;

GO

Commands completed successfully.

Completion time: 2019-11-12T08:31:08.5595316-05:00

Stewart "Arturius" Campbell SSC Guru Points: 72624 More actions · Answer 2

nice question, thanks Steve

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”

Steve Jones - SSC Editor SSC Guru Points: 736172 More actions · Answer 3

Thanks, fixed that. That's what I get for trying to edit the code after it's pasted in. Trying to set better examples with schema qualification and was just racing through each object.