Forum Stats

  • 3,824,982 Users
  • 2,260,448 Discussions


COMMENTs for indexes

Dear DBA Frank
Dear DBA Frank Member Posts: 177 Bronze Badge
edited Jun 26, 2018 2:02PM in Database Ideas - Ideas

Oracle allows the creation of comments on tables, materialized views, and views.  It also allows comments on columns, which can really help in understanding the data: COMMENT ON COLUMN employees.job_id IS 'abbreviated job title';

Nevertheless, that feature is not available for indexes.  There are, however, many different reasons for creating an index, and being able to document the rationale behind an index creation would be welcome.  Also, several catagories of people can be involved in index creation (application designer, maintenance developer, the DBA who adds a performance index...), and not all of them will know why a particular index was created.

I believe index comments would be a great enchancement to Oracle's DBMS.  Please comment!

This has been referenced as: Enh 23527965 - INTRODUCE COMMENTS FOR INDEXES

top.gunBPeaslandDBActriebMartin PreissEmad Al-MousaberxBrian BakulaFrançois DernoncourtLudovicoCaldaraBuriPini DibaskDear DBA FrankPravin TakpireborneselFranck PachotKasey Parkeruser12192189Rodrigo Jorge DBAJeff Bouliersysassysdbavinaykumar2Rajan SwSven W.user1698673KayKkulikouskiulohmannRindbækGeeky NerdmanHenning RindbækApexBineMartin WidlakeErnst LeberJonathan LewisTimur AkhmadeevBeGinfac586Andreas Buckenhoferuser7048955FatMartinRElias NemafaviantorresGregV[Deleted User]gdanby5c6e4cec-787c-4a56-a5ea-4a1afce715d1Gerald Venzl-OracleMike KutzBEDEAndreas HuberMarwimPKRTPD-OpitzAlex NuijtenWalt Lu-OracleSerge V.Racer I.user7106427connor_mc_d-OracleChoc CacSven_Svivsharm-OracleBilly VerreynneMr.Maxben_gpmdbaNiels HeckerLynne FlatleyRJAIMES-SVdominiquecomteraviraushanOlenUser_9GEWMUser_PLTUNJackKuser11970842User_930JVRogerTUser_G3UV3User_DU2XKflaviocandre.psantosUser_I5DFIUser_1JH88Thorsten Kettner
85 votes

Under Review - Voting Still Open · Last Updated