Re: [GENERAL] How to get fully qualified names with EXPLAIN

2013-06-27 Thread Bartosz Dmytrak
Works like a charm :) thanks a lot. Regards, Bartek 2013/6/27 Pavel Stehule > Hello > > > 2013/6/27 Bartosz Dmytrak : > > Hi All > > Let's assume I've got 3 tables: > > > > "OrgStructure"."tblUnits", > > "OrgStructure"."tblUnitStructure", > > "Dictionary"."tblUnits" > > > > I would like to do

Re: [GENERAL] How to get fully qualified names with EXPLAIN

2013-06-27 Thread Pavel Stehule
Hello 2013/6/27 Bartosz Dmytrak : > Hi All > Let's assume I've got 3 tables: > > "OrgStructure"."tblUnits", > "OrgStructure"."tblUnitStructure", > "Dictionary"."tblUnits" > > I would like to do the EXPLAIN: > EXPLAIN > SELECT * FROM "OrgStructure"."tblUnits", "OrgStructure"."tblUnitStructure", >

[GENERAL] How to get fully qualified names with EXPLAIN

2013-06-27 Thread Bartosz Dmytrak
Hi All Let's assume I've got 3 tables: - "OrgStructure"."tblUnits", - "OrgStructure"."tblUnitStructure", - "Dictionary"."tblUnits" I would like to do the EXPLAIN: EXPLAIN SELECT * FROM "OrgStructure"."tblUnits", "OrgStructure"."tblUnitStructure", "Dictionary"."tblUnits" (Of course its ca