oracle index NOCOMPRESS

 

CREATE INDEX "xx" ON "xx" ("PARN_GUID")  NOCOMPRESS; 
 
SELECT * FROM ALL_INDEXES WHERE table_name = 'xx';  

 

https://oracle-base.com/articles/9i/index-key-compression-9i