Results 1 to 1 of 1
  1. #1
    Join Date
    Dec 2008

    Lightbulb Unanswered: trigger performance

    query is like:

    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?
    Last edited by amar_virk83; 12-05-08 at 13:31.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts