Knowledge Walls
John Peter
Pune, Maharashtra, India
DETERMINISTIC vs NON-DETERMINISTIC in Difference between of MySQL
23527 Views
DETERMINISTIC NONDETERMINISTIC
Returns same result for same input. Returns different result for same input.
deterministic giving significant time for execution if it is giving same result. Executing method definition again and again for same input. Take more execution time compare than determisitic
When using nondeterministic for deterministic type of functions will take unwanted execution time.

Because unwantly executing again and again for the same output.
When using deterministic for nondeterministic methods might return wrong results.

Because not executing for getting different outside at all time for the same input.
  Copyright © 2014 Knowledge walls, All rights reserved
KnowledgeWalls
keep your tutorials and learnings with KnowledgeWalls. Don't lose your learnings hereafter. Save and revise it whenever required.
Click here for more details