• It depends on TransactionID as Kingston said.

    How big are the tables? Do they have many indexes?

    Regards

    IgorMi

    Igor Micev,My blog: www.igormicev.com