Return to Answer

added 167 characters in body

edited Jun 16, 2015 at 12:48

2.4k
2
21
25

Try looking in SYS.INDEXES:

select * from SYS.INDEXES where IXNAME = 'EMP_DEPARTMENT_IX'

Sounds like you are not the owner of the index, as you have noted. As long as your user can access the table data, then the index should be used by the optimizer.

Try looking in SYS.INDEXES:

select * from SYS.INDEXES where IXNAME = 'EMP_DEPARTMENT_IX'

Try looking in SYS.INDEXES:

select * from SYS.INDEXES where IXNAME = 'EMP_DEPARTMENT_IX'

Sounds like you are not the owner of the index, as you have noted. As long as your user can access the table data, then the index should be used by the optimizer.

Source Link

answered Jun 16, 2015 at 12:42

TobyLL

2.4k
2
21
25

Try looking in SYS.INDEXES:

select * from SYS.INDEXES where IXNAME = 'EMP_DEPARTMENT_IX'

Collectives™ on Stack Overflow

Return to Answer