topic Re: Indexing on table in Application Development and Automation Discussions

Indexing on table

Former Member — Mon, 23 Aug 2004 09:49:19 GMT

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

Re: Indexing on table

Former Member — Mon, 23 Aug 2004 10:54:01 GMT

Hi,

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

Cheers

Colin.

Re: Indexing on table

Former Member — Mon, 23 Aug 2004 11:53:58 GMT

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

Re: Indexing on table

nablan_umar — Thu, 26 Aug 2004 18:50:32 GMT

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.