[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 cartesian product -

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

2013-06-27 Thread Pavel Stehule
Hello 2013/6/27 Bartosz Dmytrak bdmyt...@gmail.com: 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,

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 pavel.steh...@gmail.com Hello 2013/6/27 Bartosz Dmytrak bdmyt...@gmail.com: Hi All Let's assume I've got 3 tables: OrgStructure.tblUnits, OrgStructure.tblUnitStructure, Dictionary.tblUnits I would