Hi everybody,

I'm doing some research using hints, and I have some doubts.
Suppose we are using just two tables, C and CO
1.- USE_NL(c) defines C as a Inner table, and this implicitly defines CO as the outher table. What does it mean with USE_NL(c co)?
2.- What is the benefit to use ORDERED if we have already defined USE_NL or USE_MERGE?

Thank you

Gilson
--
___________________________________________________________
Sign-up for Ads Free at Mail.com
http://promo.mail.com/adsfreejump.htm


Oracle LazyDBA home page