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