Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Is index on sys.syn$ missed?

Is index on sys.syn$ missed?

From: Andrew Protasov <oracle_at_protasov.kiev.ua>
Date: Thu, 12 Nov 98 18:00:07 +0200
Message-ID: <AA7OmIsK42@protasov.kiev.ua>

Hi,

Why did Oracle not index columns owner and name in table sys.syn$? Now it is impossible to find quickly all synonyms for the given object.

This is definition from 8.0.3. The same is in 7.2.2.

CREATE TABLE "SYN$"

("OBJ#"                            NUMBER

,"NODE" VARCHAR2(128)
,"OWNER" VARCHAR2(30)
,"NAME" VARCHAR2(30)
);

CREATE UNIQUE INDEX "I_SYN1" ON "SYN$"("OBJ#"); Andrew Protasov Received on Thu Nov 12 1998 - 10:00:07 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US