What is the Gather_plan_statistics hint?
Could you please explain what the Gather_plan_statistics hint is in the context of database optimization and how it can be used to enhance query performance? Additionally, could you provide some scenarios where this hint might be particularly beneficial and any potential drawbacks or considerations to keep in mind when utilizing it?