• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 463
  • Last Modified:

"Deterministic and Nondeterministic Functions" it is important?

I am a developer of database objects, that serves me know
"Deterministic and Nondeterministic Functions"
0
enrique_aeo
Asked:
enrique_aeo
  • 2
1 Solution
 
BrandonGalderisiCommented:
A deterministic function will always give the same output for the same input.  
A non-deterministic will not always.
0
 
enrique_aeoAuthor Commented:
I understand, but that helps me to know that when I'm programming.
0
 
enrique_aeoAuthor Commented:
I understand that I do not know this for indexes on computed columns, but there are some more reasons?
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now