Table Hint to eliminate index usage

[diggerfm]

I would like to eliminate using any index in a select stmt, does anyone know if it's possible and what the syntax would be (I presume index=, but = to what?)?

Thank you!

fyi, it's due to referencing sqlserver tables via an Oracle gateway - but indexes on the table exceed the oracle object limit of 30 chars, so the query crashes.

 

[bperry]

I think INDEX(0) might do it, but I'm not sure of the exact syntax. I imagine this must be pretty close

Select * from mytable INDEX(0)

or

Select * from mytable WITH INDEX(0)

 

[bperry]

Just tried a little syntax test on my system. I think it looks a little more like this:

select * from clients with (index(0))

or

select * from clients (index(0))

 

[diggerfm]

Thank you! Works great from Ent Mgr...I'm going to see if I can get the syntax working across the Oracle Gateway...