Rhaoni,
> I could .. but this way I wont be used because Oracle doesn't accept such
> sintax ! I changed gsames00.ano_mes from varchar to text ! But it still not
> fast enough to take Oracle's place !!!
> I still trying to do so ...
Well, your basic problem is that performance tuning for *any* database often
requires use of database-specific syntax. You would be having the same
problem, in the opposite direction, if you were trying to port a PostgreSQL
app to Oracle without changing any syntax.
Here's syntax Oracle should accept:
... gsames00.ano_mes = (CAST(to_char(ftnfco00.data_emissao,'YYYYMM') AS
VARCHAR)) AND
...
--
Josh Berkus
Aglio Database Solutions
San Francisco