Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Indexing on table

Former Member

‎2004 Aug 23 10:49 AM

0 Likes
2,973

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

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

Reply
3 REPLIES 3
Read only

Former Member

‎2004 Aug 23 11:54 AM

0 Likes
681

Hi,

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

Cheers

Colin.

Read only

Former Member

‎2004 Aug 23 12:53 PM

0 Likes
681

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

Read only

nablan_umar
Product and Topic Expert
Product and Topic Expert

‎2004 Aug 26 7:50 PM

0 Likes
681

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.