You have a table that contains a string column. Most of the rows have the same value. You need to create a multistep stored procedure that meets the following requirements: - Accepts a text input…

You have a table that contains a string column. Most of the rows have the same value. You need to create a multistep stored procedure that meets the following requirements:

• Accepts a text input parameter
• Provides optimal performance for all input values
• Has only one step using the input parameter as a predicate

What should you use?