View SQL bug with local indexes

[sagizvi]

The view sql window still generates global indexes instead of local indexes.

The index should, at least, contain the word "local" .
I've been nagging about this bug for the last 4 years.

It causes damages . DBAs and Programmers generate GLOBAL indexes instead of LOCAL indexes because of this bug.

It caused us at least 2 production performance problems !!!!!!

please fix it !!!!!!!!

 

[Marco Kalter]

There is indeed no explicit support for local indexes. This is on the list of enhancement requests.

 

[sagizvi]

I understand that pl/sql developer doesnt support local indexes.
The fact that it displays Local indexes DDL as a GLOBAL index is a BUG . It is not a lack of "support" . At least it shouldn't allow displaying DDL of such indexes.
When will you fix this bug ?

 

[Marco Kalter]

Support for local indexes is added in 9.0.