07-31-2023, 09:01 AM
I have read that one should not analyze a temp table, as it screws up the table statistics for others. What about an index? If I put an index on the table for the duration of my program, can other programs using the table be affected by that index?
**Does an index affect my process, and all other processes using the table?
or Does it affect my process alone?**
None of the responses have been authoritative, so I am offering said bribe.
**Does an index affect my process, and all other processes using the table?
or Does it affect my process alone?**
None of the responses have been authoritative, so I am offering said bribe.