Indexing on table

[Former Member]

hi,

I have encountered the following index statement used in a sql statement...can anybody explain me where i can see this index name. I have checked in se11 with related table

this EKET______0 index is not there.

%_hints ORACLE 'INDEX (EKET EKET______0)'

Thanks for the help

sekaran

[Former Member]

Go to SE11. Click on dropdown Utilities. Then select Database Utility. Select Activate and adjust database. Index 0 of a table should be defaulted on all tabled. There could be some problem with database. But you should be able to regenerate the index.

[Former Member]

Hi,

_0 means it is using the primary key of the table.

Cheers

Colin.

[Former Member]

Go to SE11 transaction with your EKET table. Than use from menu Utilities -> Database object -> Display. Than scroll down and you will see all defined indexes with their full name

regards,

Andrzej

[nablan_umar]

Go to SE11. Click on dropdown Utilities. Then select Database Utility. Select Activate and adjust database. Index 0 of a table should be defaulted on all tabled. There could be some problem with database. But you should be able to regenerate the index.