Hi, I use Python and SQLAlchemy to access an Oracle 11 database. As far as I think, SQLAlchemy always use prepared statements.
On a huge table (4 millions records), correctly indexed, SQLAlchemy filters queries doesn't use the index, so doing a full table scan is very slow ; using the same SQL code in a "raw" SQL editor (SQLplus) make Oracle use the index with good performances. We tried to add "+index" hints on requests, without effect on Oracle execution path which still doesn't want to use the index. Any idea ? Is it possible to really force Oracle to use an index, or to make SQLAlchemy to not use prepared statements ?? Best regards, Thierry -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.
