dbms_metadata.get_ddl does not extract all the indexes but other wise its performance is pretty good.