Re: How to force an Index ?

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