Quote:
Originally posted by pareshg
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
Forgive me for asking the obvious but do you have any control over generation of statistics on the tables at the remote site?