Post reply

Trigger after Insert?

  • September 24, 2008 at 1:40 am

    #94136

    Dear all, I've a table that is modified daily and has a huge amount of data, and for performance issue, I need to insert the latest daily data into a another table to perform search operations with better spped, and so, I think I need to write a trigger after insert on the first table to insert the latest rows in the other table.

    How can I do that?

  • September 24, 2008 at 2:26 am

    #876167

    From inside your trigger, you can access the INSERTED virtual table. This table will have the same structure as your main table and contain only the newly inserted data. You can then write an INSERT INTO statement which SELECTS columns FROM INSERTED.

    .

  • September 24, 2008 at 7:13 am

    #876323

    and for performance issue, I need to insert the latest daily data into a another table to perform search operations with better spped

    Have you created any indexes to improve the search?

    Any horizontal partitions?

    I feel, creating a new table is not a good idea, just for search operation. Trigger may cause performance issue.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply