Which is better in performance - CONSTRAINT or TRIGGER over
a column which restricts say an input of particular value
in a column of a table?

Answer Posted / guest

Constraint is better in terms of performance for same
operation. Why??

Is This Answer Correct ?    0 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how to use DTS package in 2000,2005,2008 in sql server

1442


explain how to create a new schema in a database? : Sql server database administration

569


How to write a query with an inner join in ms sql server?

536


Is null in sql server?

532


What is Replication?

617






What are the different types of stored procedures?

533


How to execute a sql statement using odbc_exec()?

559


How to verify the port number of the sql server?

543


What are rest-style architecture's?

149


Describe in brief authentication modes in sql server.

553


Can a table have 2 primary keys?

499


What does the update command do?

601


What is difference between group by and having?

548


Explain indexing and what are the advantages of it?

513


What is plan freezing?

570