The piston noise in the later Vortec 5.3 & 5.7 is not a problem, as stated by GM.
In 95 your Tahoe is the TBI engine (throttle body injected).
You need to determine if it is piston noise or main bearing knock. This engine was common to have main bearing noise, just after start up, when cold. It was due to the plumbing involved on the oil cooler lines and idle speed condition. The cure for most of them was a prom replacement in the computer, which gave the engine a lower idle speed when cold, for a few moments to get oil moving in the system. This knock usually only lasted for 3-4 seconds. Piston noise, if no oil consumption is going on, is not gonna be an issue.