I am trying to implement insert trigger on a table where I am joining two tables.
the other table is a master table and has a constraint defined over it.
the other thing is that the master tables table has clustered unique index formed over it's 4 PK keys.
now the table on which I am creating trigger has 4 columns and all are the clusterd index keys (constraint also exists over this table)
when I am executing sp_helpjoins tab1, tabl2 only one column is elgible for join.
there issue here is the performance issue.
my question is:
A>can I implement join on clustered index keys in a trigger query?
B>what about performmance of the trigger?