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
What is the fillfactor concept in indexes?
Difference between report and query parameter. Why do we need different type of parameter?
What are different types of raid configurations? : SQL Server Architecture
What do you mean by data integrity?
Can an automatic recovery be initiated by a user?
How to select all columns of all rows from a table with a select statement in ms sql server?
What is difference between delete & truncate commands?
What is view in sql?
Tell me in brief how sql server enhances scalability of the database system?
Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?
What is data compression?
How can I create a new template for import ? : sql server management studio
Tell me what is log shipping?
What is the difference between primary key and unique constraints?
Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?