Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 1 down vote favorite

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?

share|improve this question

1 Answer

up vote 2 down vote

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

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.