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 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html