The SQLPlus utility shows the following prompt:SQL> Connect to an Oracle database by typing ... Enter the Oracle "ALTER INDEX" command, using the following code as an example:ALTER INDEX table ...

For example, a ZIP code field might be a string ... that’s probably the right thing to do. In a transactional SQL database, index tuning is a constant battle for DBAs and developers.