<div>
has the index changed or the volume of data? &nbsp;Has it always been .5 million? &nbsp;is it still .5 million?
</div>


has the index changed or the volume of data?  Has it always been .5 million?  is it still .5 million?

<div>
<div class="content wysiwyg-content">
Hello<br />
<br />
ctx_ddl.optimize_index() takes a long time<br />
It runs for 60-90 mins earlier it was use to complete within 10 mins<br />
Number of rows approx 0.5 million <br />
<br />
Kindly let me know reason what all possible reasons can be for its delay.<br />
<br />
Regards<br />
Ankush 
</div>
</div>


Hello

ctx_ddl.optimize_index() takes a long time
It runs for 60-90 mins earlier it was use to complete within 10 mins
Number of rows approx 0.5 million 

Kindly let me know reason what all possible reasons can be for its delay.

Regards
Ankush 

ctx_ddl.optimize_index() takes a long time

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.