Hi, I'm using SQLAlchemy 0.7.5 in a web application accessing several tables containing between 2.5 and 3.5 millions records; these tables are indexed correctly. Database is Oracle 10g (release 10.2.0.4).
My problem is quite simple : when querying the database through SQLAlchemy (via "session.query(MyClass).filter(...)"), the execution plan (when using indexed criterias) doesn't use table indexes but does a full scan which takes between 10 and 15 seconds; when querying the database through a simple SQL query (in Tora for example), indexes are normaly used and the result is immediate. I tried to play in SQLAlchemy with optimizer modes and hints, but it doesn't change anything. Any idea ? Regards, Thierry -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To view this discussion on the web visit https://groups.google.com/d/msg/sqlalchemy/-/UMipFKddLvYJ. To post to this group, send email to sqlalchemy@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.