What should I use to increase performance. View/Query/Temporary Table
- by Shantanu Gupta
I want to know the performance of using Views, Temp Tables and Direct Queries Usage in a Stored Procedure.
I have a table that gets created every time when a trigger gets fired. I know this trigger will be fired very rare and only once at the time of setup.
Now I have to use that created table from triggers at many places for fetching data and I…