Radar systems model the emission medium simply as a delay and attenuation, assuming that the received signal from a point target is identical to the transmitted signal. However, when it comes to oil well walls, which are long metal cylinders, they exhibit frequency-selective behaviour and have a specific frequency response. If the transmitted waveform exceeds the channel's bandwidth, no signal is received. A low channel bandwidth results in reduced signal resolution, making it challenging to locate oil well perforations. Therefore, this paper aims to discuss the properties of the optimal waveform in terms of both signal-to-noise ratio (SNR) and resolution objectives. Additionally, it investigates conventional radar waveforms to determine which one performs best in an oil well context. The study reveals that achieving the optimum SNR and the highest resolution simultaneously is not possible, and a trade-off must be considered during waveform design.