Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Creating a constraint verses Trigger check

Status
Not open for further replies.
zambrtp

zambrtp

Programmer
Jan 17, 2003
42
US
Can anyone tell me what the difference in performance if there is a contraint created to check data integrity vs a trigger created to do the same?
Thanks
 
Sort by date Sort by votes
Contraint is faster and more efficient as Oracle does the checking internally and the constraint can be deferred and will not become invalid. However a trigger can have funtionality which a constraint can not provide.

The ONE ( HP-UX + Solaris + AIX + Tru64 = Unix)
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Chopstik
  • Locked
  • Question
How to identify a package based on a code snippet 1
Replies
1
Views
323
Andrzejek
Andrzejek
Andrzejek
  • Locked
  • Question
Get part of a string with SQL 1
Replies
2
Views
375
Andrzejek
Andrzejek
Andrzejek
  • Locked
  • Question
Format a number - TO_CHAR() 2
Replies
5
Views
406
SkipVought
S
George L
  • Locked
  • Question
web app not saving "all" records suddenly
Replies
3
Views
359
carp
carp
Olutee360
  • Locked
  • Question
Group by using values in a range 1
Replies
4
Views
127
Olutee360
Olutee360

Part and Inventory Search

Sponsor

Back
Top