I came across the term Transaction Path Analysis which I am not familiar with. A Google search resulted in only a few results, most of which seem to assume everyone knows what it means. From these my understanding is that it is about tracking what columns are used by queries to access data, in preparation for deciding indexes. This seems like common sense, but I'm surprised I can't find more specifics on it.
Is there a concise definition for transaction path analysis, a process for completing one, or any alternative more commonly used phrases that mean the same thing?
Best Answer
This term relates to the process of identifying the significant events in the transaction life-cycle, including error-processing, auditing, save-points, nested transactions, and distribution paths for distributed transactions.
I think you may find more results with the synonymous term Transaction Life-cycle Analysis.