The rule of thumb for me is that if you use select * into a data structure. or use * to denote all fields into a data structure, then you’ll need to decide:
– If there are more or less columns (fields) than before, you will need to recompile.
– If the field list remains the same and in the same order, you probably won’t.
For this reason, it’s good practice to name the columns you want rather than fetching everything.
It does depend on what you’re changing. If it’s just selection criteria in an SQL view, then you probably don’t need to recompile.