IOT

Besause this is IOT then optimazer can use only SECONDARY index for not PK field. This operation hasn't some perfomence as B+ or bitmap index.

Thanks but I wanted to know if I can sort the pty_nam column in IOT. How?

Yes, you can use usuall "ORDER BY ..." construction.