÷ÓÅ ÚÁÐÒÏÓÙ (SELECT) Ó Ñ×ÎÙÍ ÕËÁÚÁÎÉÅÍ ÐÌÁÎÁ Ë ×ØÀÛËÁÍ ÓÙÐÑÔÓÑ ÓÌÅÄÕÀÝÅÊ
ÏÛÉÂËÏÊ:
This operation is not defined for system tables.
unsuccessful metadata update.
request depth exceeded. (Recursive definition?).
ÐÅÒ×ÙÅ ÎÅÓËÏÌØËÏ ÚÁÐÒÏÓÏ× Ó ÍÏÍÅÎÔÁ ÁÔÁÞÁ Ë âä ×ÙÐÏÌÎÑÀÔÓÑ ÎÏÒÍÁÌØÎÏ, ÚÁÔÅÍ
ÎÁÞÉÎÁÀÔÓÑ ÔÏÌØËÏ ÏÛÉÂËÉ
CREATE TABLE T1 (ID INTEGER NOT NULL,NAME INTEGER NOT NULL);
ALTER TABLE T1 ADD CONSTRAINT PK_T1 PRIMARY KEY (ID);
CREATE VIEW VT(ID,NAME) AS select * from t1;
ÐÏ×ÔÏÒÑÔØ ÒÁÚ 30-100:
select * from vt where id=1 PLAN (vt T1 INDEX (PK_T1))
*********
Windows2003
ods 11.1, 11.2
