From issues at jboss.org Fri Jun 3 16:35:02 2016 Content-Type: multipart/mixed; boundary="===============1541267727525571332==" MIME-Version: 1.0 From: Steven Hawkins (JIRA) To: teiid-issues at lists.jboss.org Subject: [teiid-issues] [JBoss JIRA] (TEIID-4122) Improve performance of odbc client column metadata query Date: Fri, 03 Jun 2016 16:35:01 -0400 Message-ID: In-Reply-To: JIRA.12613781.1460034571000@Atlassian.JIRA --===============1541267727525571332== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable [ https://issues.jboss.org/browse/TEIID-4122?page=3Dcom.atlassian.jira= .plugin.system.issuetabpanels:all-tabpanel ] Steven Hawkins closed TEIID-4122. --------------------------------- > Improve performance of odbc client column metadata query > -------------------------------------------------------- > > Key: TEIID-4122 > URL: https://issues.jboss.org/browse/TEIID-4122 > Project: Teiid > Issue Type: Quality Risk > Components: ODBC > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.0 > > > With cursoring, the client issues: > select n.nspname, c.relname, a.attname, a.atttypid, t.typname, a.attnum, = a.attlen, a.atttypmod, a.attnotnull, c.relhasrules, c.relkind, c.oid, pg_ge= t_expr(d.adbin, d.adrelid), case t.typtype when 'd' then t.typbasetype else= 0 end, t.typtypmod, c.relhasoids from (((pg_catalog.pg_class c inner join = pg_catalog.pg_namespace n on n.oid =3D c.relnamespace and c.oid =3D ) inner join pg_catalog.pg_attribute a on (not a.attisdropped) and a.at= tnum > 0 and a.attrelid =3D c.oid) inner join pg_catalog.pg_type t on t.oid= =3D a.atttypid) left outer join pg_attrdef d on a.atthasdef and d.adrelid = =3D a.attrelid and d.adnum =3D a.attnum order by n.nspname, c.relname, attn= um > We should ensure that this is being planned optimally. -- This message was sent by Atlassian JIRA (v6.4.11#64026) --===============1541267727525571332==--