On Fri, 2025-04-25 at 09:43 -0700, Bo Guo wrote: > When creating a temporary table for additional sql operations in a stored function, > should I worry about building indexes on the temp table to increase performance when > the temp table's row count exceeds a certain threshold? If so, is there a rule of > thumb for the row count threshold? Well, if a table is small, you don't need an index. It is hard to say what is small. For one, it depends on the size of the rows. In general, I would say that it never pays to build an index on a temporary table unless you are using that index at least twice. Yours, Laurenz Albe
