When using The SQL Tuning Advisor in SQL-Developer. I get often some recommendations to accept a SQL-Profil. I guess it is a good idea to do so.
But is this similar to proposed indexes, which I can deploy to similar databases or is this something, that must be analyzed for each individual database?
Best Answer
SQL Profiles are basically a kind of statistics rather than a database object like an index, but they can be transported to another database - see this SF question for how