Re: FTS in SQL Query ... Advice please?

Your query didn't return any single row? What filter predicates on
GENERAL_ACCT_MAST_TABLE made this to happen? Is this a common behavior
(not to return any data)?

Mixing histograms with cursor_sharing=force isn't a very good idea
unless you are certain that optimizer will _always_ pick suitable bind
variable values during the hard parse (bind variable peeking). Or is
that "similar"?

Alexander Fatkulin,
Senior Oracle DBA
--
http://www.freelists.org/webpage/oracle-l

Other related posts: