Index Creation Errors and Deterministic Functions Flashcards by Cody Smith

Q

Can an index be created on a computed column?

A

Yes

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Can an index be created on a computed column that includes a non-deterministic function?

A

No

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

What is the only string function that is non-deterministic?

A

Format

How well did you know this?

1

Not at all

2

3

4

5

Perfectly