Guys,

Are there any drawbacks in using RULE hints in some of the quries in the packages?

Some of the quries written in packages are querying data from few tables from remote database. And what I found out is if I use the Rule hint in such select queries, they does take less time.

Database - 8.1.7 on Windows 2000
Optimizer_mode - choose

Any suggestions are welcome.

Thanks