First: `join` allows you to specify a join condition. You can often use
that to bypass tables or automat selects
query(A).join(B, A.id == B.id_a)
But: what you really need to do is check the generated SQL to see what is
going on, and tweak that to eliminate the joins/fields you don't
Hi!
I have got, 3 tables in a Oracle database. I build the connection and
everything. :-) When I generate a query from one table it is fast, really
fast. But I created another query I use 3 tables, but only two is
neccesseary. The "*Q*" connected the "*P*" and the "*C*" (one (*Q*) to many
Thanks for opening an issue in cx_oracle, I hope the issue will be solved in
their side.
You suggested using a lengthed string but I'm using sqlalchemy to create my
table as well and when it sees text, it uses clob automatically... Is there any
way around it like maybe say that small strings