[cx-oracle-users] Optimizer Hints in Queries

[Andrew S. <saw...@gm...>]

I have looked through many archived messages trying to find some details on
using hints in queries.  I am using cc_Oracle 5.1.1 and oracle 11g -
issuing a query, presuming I have a connection and a cursor, such as:
cursor.execute ("select /*+ first_rows °/ x, y, a from
my_materialized_view")
Fails with "invalid character" - I am presuming that is from the / in the
hint - I have tried various attempts too escape or other wise get this to
work.....no luck.  Also no luck googling variations of my issue...
I am hoping someone here can provide  some help.
Cheers,
Andrew