From user-return-21623-archive-asf-public=cust-asf.ponee.io@ignite.apache.org Tue Sep 4 10:38:33 2018 Return-Path: X-Original-To: archive-asf-public@cust-asf.ponee.io Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by mx-eu-01.ponee.io (Postfix) with SMTP id B90C9180629 for ; Tue, 4 Sep 2018 10:38:32 +0200 (CEST) Received: (qmail 52222 invoked by uid 500); 4 Sep 2018 08:38:31 -0000 Mailing-List: contact user-help@ignite.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@ignite.apache.org Delivered-To: mailing list user@ignite.apache.org Received: (qmail 52212 invoked by uid 99); 4 Sep 2018 08:38:31 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd3-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 04 Sep 2018 08:38:31 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd3-us-west.apache.org (ASF Mail Server at spamd3-us-west.apache.org) with ESMTP id 3CFA01800C7 for ; Tue, 4 Sep 2018 08:38:31 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 2.138 X-Spam-Level: ** X-Spam-Status: No, score=2.138 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, FREEMAIL_ENVFROM_END_DIGIT=0.25, HTML_MESSAGE=2, RCVD_IN_DNSWL_NONE=-0.0001, RCVD_IN_MSPIKE_H2=-0.001, SPF_PASS=-0.001, T_DKIMWL_WL_MED=-0.01] autolearn=disabled Authentication-Results: spamd3-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com Received: from mx1-lw-us.apache.org ([10.40.0.8]) by localhost (spamd3-us-west.apache.org [10.40.0.10]) (amavisd-new, port 10024) with ESMTP id mreK3sGI_nB9 for ; Tue, 4 Sep 2018 08:38:29 +0000 (UTC) Received: from mail-oi0-f48.google.com (mail-oi0-f48.google.com [209.85.218.48]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with ESMTPS id D6FE95F19A for ; Tue, 4 Sep 2018 08:38:28 +0000 (UTC) Received: by mail-oi0-f48.google.com with SMTP id 8-v6so5271522oip.0 for ; Tue, 04 Sep 2018 01:38:28 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:references:in-reply-to:from:date:message-id:subject:to; bh=MswuxTE2HVFjLeRfMCszF40h+paGye4/YUrO9L1ToKY=; b=GucvVZ3EK7dTL/z7tL4Z7MIhLl0WADE4U+rATgDRMzIKd4PCG+6fbMA+RCx1A35n3+ dGGE21ReBOnTPbj/JwFtqIkrasO62ogWv8KunrWQb5wOeV+clw9sF7ZyB4ON4/FSeQQw CyiQSXr4zc1duzD5H4iE7dYA1YdOhV3kp8G2sPCLhEtdTU7gUyJLZD41ziLlkJ8UATO6 kAjy+GEX+n95AyIOzQjqRrq9z/ioq1eezKgPob1tSJiZzfYhJnsmK+u7YLerlsnnpp8b +STBB+UTNI5ugmX+fqpIGvhIGv0CGi7kbFmTnXHTCE8fo9p+whj+Y9/Ty8YpmXrMsCsi og7Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to; bh=MswuxTE2HVFjLeRfMCszF40h+paGye4/YUrO9L1ToKY=; b=Y3+S6ove7M2dmOh4YbvVQqaCIBKgukty7y2TQ994wSA0YT/xTEI9B8u0N5Qjxv/ghX Q6RLzJj4rcSPxUojN5kUyUpYD6CgluXt3dO5FmSL9vpFXtT+xVHGlcEe7YEef0KDo+Qk i/E9ZfqUR3EQj9T4AU58aYXvcNK77wHr5qrWF/Vov9b/N3TM4/UcWkB/0vfdE7IQqV/j PSYXTyOHjgw9BGnLkFbe77eXfpaTvXkvc0+L0HjruxBKyui1rU3gcSo6MIfPbvNjxTwr bilgyMaLLBZn6h2pbMyYfM1iAdk7q/NjN2ezJYybXYl7F3OGbU/rR8sPeq2Pq6/7loz2 1Xfg== X-Gm-Message-State: APzg51BFGrwargYC30c3UG87Xenm/mcYcN9Xwu/PYPBUnYxRI9+avr6c bs1KAlFISN0s9pEWlOIPgew47DutPSeQK+b6xuEgSbn4 X-Google-Smtp-Source: ANB0VdbydEJNp7LKt0uyM9/eA8MeyPcEOKGhh6ep0CCattBn7fyrCFYY+5v5Vb/ISHeJQABfl089pN4qxd7BbhbdR80= X-Received: by 2002:aca:c54e:: with SMTP id v75-v6mr1873107oif.276.1536050308049; Tue, 04 Sep 2018 01:38:28 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Prasad Bhalerao Date: Tue, 4 Sep 2018 14:08:16 +0530 Message-ID: Subject: Re: Query execution too long even after providing index To: user@ignite.apache.org Content-Type: multipart/alternative; boundary="000000000000f7efea0575079416" --000000000000f7efea0575079416 Content-Type: text/plain; charset="UTF-8" I tried changing SqlIndexMaxInlineSize to 32 byte and 100 byte using cache config. ipContainerIpV4CacheCfg.setSqlIndexMaxInlineSize(32/100); But it did not improve the sql execution time. Sql execution time increases with increase in cache size. It is a simple range scan query. Which part of the execution process might take time in this case? Can you please advise? Thanks, PRasad On Mon, Sep 3, 2018 at 8:06 PM Andrey Mashenkov wrote: > HI, > > Have you tried to increase index inlineSize? It is 10 bytes by default. > > Your indices uses simple value types (Java primitives) and all columns can > be easily inlined. > It should be enough to increase inlineSize up to 32 bytes (3 longs + 1 int > = 3*(8 /*long*/ + 1/*type code*/) + (4/*int*/ + 1/*type code*/)) to inline > all columns for the idx1, and up to 27 (3 longs) for idx2. > > You can try to benchmark queries with different inline sizes to find > optimal ratio between speedup and index size. > > > > On Mon, Sep 3, 2018 at 5:12 PM Prasad Bhalerao < > prasadbhalerao1983@gmail.com> wrote: > >> Hi, >> My cache has 1 million rows and the sql is as follows. >> This sql is taking around 1.836 seconds to execute and this time >> increases as I go on adding the data to this cache. Some time it takes more >> than 4 seconds. >> >> Is there any way to improve the execution time? >> >> *SQL:* >> SELECT id, moduleId,ipEnd, ipStart >> FROM IpContainerIpV4Data USE INDEX(ip_container_ipv4_idx1) >> WHERE subscriptionId = ? AND moduleId = ? AND (ipStart <= >> ? AND ipEnd >= ?) >> UNION ALL >> SELECT id, moduleId,ipEnd, ipStart >> FROM IpContainerIpV4Data USE INDEX(ip_container_ipv4_idx1) >> WHERE subscriptionId = ? AND moduleId = ? AND (ipStart <= >> ? AND ipEnd >= ?) >> UNION ALL >> SELECT id, moduleId,ipEnd, ipStart >> FROM IpContainerIpV4Data USE INDEX(ip_container_ipv4_idx1) >> WHERE subscriptionId = ? AND moduleId = ? AND (ipStart >= >> ? AND ipEnd <= ?) >> >> *Indexes are as follows:* >> >> public class IpContainerIpV4Data implements Data, UpdatableData { >> >> @QuerySqlField >> private long id; >> >> @QuerySqlField(orderedGroups = {@QuerySqlField.Group(name = "ip_container_ipv4_idx1", order = 1)}) >> private int moduleId; >> >> @QuerySqlField(orderedGroups = {@QuerySqlField.Group(name = "ip_container_ipv4_idx1", order = 0), >> @QuerySqlField.Group(name = "ip_container_ipv4_idx2", order = 0)}) >> private long subscriptionId; >> >> @QuerySqlField(orderedGroups = {@QuerySqlField.Group(name = "ip_container_ipv4_idx1", order = 3, descending = true), >> @QuerySqlField.Group(name = "ip_container_ipv4_idx2", order = 2, descending = true)}) >> private long ipEnd; >> >> @QuerySqlField(orderedGroups = {@QuerySqlField.Group(name = "ip_container_ipv4_idx1", order = 2), >> @QuerySqlField.Group(name = "ip_container_ipv4_idx2", order = 1)}) >> private long ipStart; >> >> } >> >> >> *Execution Plan:* >> >> 2018-09-03 19:32:03,098 232176 [pub-#78%springDataNode%] INFO >> c.q.a.g.d.IpContainerIpV4DataGridDaoImpl - SELECT >> __Z0.ID AS __C0_0, >> __Z0.MODULEID AS __C0_1, >> __Z0.IPEND AS __C0_2, >> __Z0.IPSTART AS __C0_3 >> FROM IP_CONTAINER_IPV4_CACHE.IPCONTAINERIPV4DATA __Z0 USE INDEX >> (IP_CONTAINER_IPV4_IDX1) >> /* IP_CONTAINER_IPV4_CACHE.IP_CONTAINER_IPV4_IDX1: SUBSCRIPTIONID = ?1 >> AND MODULEID = ?2 >> AND IPSTART <= ?3 >> AND IPEND >= ?4 >> */ >> WHERE ((__Z0.SUBSCRIPTIONID = ?1) >> AND (__Z0.MODULEID = ?2)) >> AND ((__Z0.IPSTART <= ?3) >> AND (__Z0.IPEND >= ?4)) >> 2018-09-03 19:32:03,098 232176 [pub-#78%springDataNode%] INFO >> c.q.a.g.d.IpContainerIpV4DataGridDaoImpl - SELECT >> __Z1.ID AS __C1_0, >> __Z1.MODULEID AS __C1_1, >> __Z1.IPEND AS __C1_2, >> __Z1.IPSTART AS __C1_3 >> FROM IP_CONTAINER_IPV4_CACHE.IPCONTAINERIPV4DATA __Z1 USE INDEX >> (IP_CONTAINER_IPV4_IDX1) >> /* IP_CONTAINER_IPV4_CACHE.IP_CONTAINER_IPV4_IDX1: SUBSCRIPTIONID = ?5 >> AND MODULEID = ?6 >> AND IPSTART <= ?7 >> AND IPEND >= ?8 >> */ >> WHERE ((__Z1.SUBSCRIPTIONID = ?5) >> AND (__Z1.MODULEID = ?6)) >> AND ((__Z1.IPSTART <= ?7) >> AND (__Z1.IPEND >= ?8)) >> 2018-09-03 19:32:03,098 232176 [pub-#78%springDataNode%] INFO >> c.q.a.g.d.IpContainerIpV4DataGridDaoImpl - SELECT >> __Z2.ID AS __C2_0, >> __Z2.MODULEID AS __C2_1, >> __Z2.IPEND AS __C2_2, >> __Z2.IPSTART AS __C2_3 >> FROM IP_CONTAINER_IPV4_CACHE.IPCONTAINERIPV4DATA __Z2 USE INDEX >> (IP_CONTAINER_IPV4_IDX1) >> /* IP_CONTAINER_IPV4_CACHE.IP_CONTAINER_IPV4_IDX1: SUBSCRIPTIONID = ?9 >> AND MODULEID = ?10 >> AND IPSTART >= ?11 >> AND IPEND <= ?12 >> */ >> WHERE ((__Z2.SUBSCRIPTIONID = ?9) >> AND (__Z2.MODULEID = ?10)) >> AND ((__Z2.IPSTART >= ?11) >> AND (__Z2.IPEND <= ?12)) >> 2018-09-03 19:32:03,098 232176 [pub-#78%springDataNode%] INFO >> c.q.a.g.d.IpContainerIpV4DataGridDaoImpl - ((SELECT >> __C0_0 AS ID, >> __C0_1 AS MODULEID, >> __C0_2 AS IPEND, >> __C0_3 AS IPSTART >> FROM PUBLIC.__T0 >> /* IP_CONTAINER_IPV4_CACHE."merge_scan" */) >> UNION ALL >> (SELECT >> __C1_0 AS ID, >> __C1_1 AS MODULEID, >> __C1_2 AS IPEND, >> __C1_3 AS IPSTART >> FROM PUBLIC.__T1 >> /* IP_CONTAINER_IPV4_CACHE."merge_scan" */)) >> UNION ALL >> (SELECT >> __C2_0 AS ID, >> __C2_1 AS MODULEID, >> __C2_2 AS IPEND, >> __C2_3 AS IPSTART >> FROM PUBLIC.__T2 >> /* IP_CONTAINER_IPV4_CACHE."merge_scan" */) >> >> >> > > -- > Best regards, > Andrey V. Mashenkov > --000000000000f7efea0575079416 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable

I tried changing=C2=A0SqlIndexMaxInlineSize to 32 byte and 100 byte using= cache config.

<= div>ipContainerIpV4CacheCfg.setSqlIndexMaxInlineSize(32/100);<= /div>

But it did not improve the sql = execution time. Sql execution time increases with increase in cache size.

It is a simple range scan= query. Which part of the execution process might take time in this case?

Can you please advise?

Thanks,
PRasad

<= /div>
On Mon, Sep 3,= 2018 at 8:06 PM Andrey Mashenkov <andrey.mashenkov@gmail.com> wrote:
HI,

Have you tried to increase index = inlineSize? It is 10 bytes by default.

Your indice= s uses simple value types (Java primitives) and all columns can be easily i= nlined.
It should be enough to increase inlineSize up to 32 bytes= (3 longs + 1 int =3D 3*(8 /*long*/ + 1/*type code*/)=C2=A0+ (4/*int*/ + 1/= *type code*/)) to inline all columns for the idx1, and up to 27 (3 longs) f= or idx2.

You can try to benchmark queries with dif= ferent inline sizes to find optimal ratio between speedup and index size.



=
On Mon, Sep 3, 2018 at 5:12 PM Prasad Bhalerao <prasadbhalerao19= 83@gmail.com> wrote:
Hi,
My cache has 1 million rows and the sql is as follows.
Th= is sql is taking around 1.836 seconds to execute and this time increases as= I go on adding the data to this cache. Some time it takes more than 4 seco= nds.

Is there any way to improve the execution tim= e?

SQL:
SELECT id, mod= uleId,ipEnd, ipStart
FROM IpContainerIpV4Data USE INDEX(ip_container_ipv= 4_idx1)
WHERE subscriptionId =3D ?=C2=A0 AND moduleId=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 =3D ? AND (ipStart=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0 <=3D ? AND ipEnd=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0 >=3D ?)
UNION ALL
SELECT id, moduleId,ipE= nd, ipStart
FROM IpContainerIpV4Data USE INDEX(ip_container_ipv4_idx1)WHERE subscriptionId =3D ? AND moduleId=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0 =3D ? AND (ipStart=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0 <=3D ? AND ipEnd=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0 >=3D ?)
UNION ALL
SELECT id, moduleId,ipEnd, ipStart
= FROM IpContainerIpV4Data USE INDEX(ip_container_ipv4_idx1)
WHERE subscri= ptionId =3D ? AND moduleId=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 = =3D ? AND (ipStart=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 >=3D ? AND = ipEnd=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 <=3D ?= )

Indexes are as follows:
public class IpContainerIpV4Data <=
span style=3D"color:rgb(0,0,128);font-weight:bold">implements Data&l=
t;DefaultDataAffinityKey>, UpdatableData<DefaultDataAffinityKey> {=


  @QuerySqlField
  private long id;

  @QuerySqlField(orderedGroups =3D {@QuerySqlField.Group(name =3D "ip_container_ipv4_idx1", order =3D 1)})
  private int moduleId;

  @QuerySqlField(orderedGroups =3D {@QuerySqlField.Group(name =3D "ip_container_ipv4_idx1", or=
der =3D 0),
      @QuerySqlField.Group(name =3D "ip_container_ipv4_idx2"=
, order =3D 0)})
  private long subscriptionId;
<=
br>  @QuerySqlField(orderedGrou=
ps =3D {@QuerySqlField.Group(na=
me =3D "ip_contain=
er_ipv4_idx1", order =3D 3, descending =3D t=
rue),
      @QuerySqlField.G=
roup(name =3D &q=
uot;ip_container_ipv4_idx2", order =3D 2, descending =3D true)})
  private long ipEnd;

  @Quer=
ySqlField(orderedGroups =3D {@Q=
uerySqlField.Group(name =3D "ip_container_ipv4_idx1", order =3D 2),
      @QuerySqlField.Group(name =3D "ip_container_ipv4_idx2", order =3D <=
span style=3D"color:rgb(0,0,255)">1)})
  private long ipStart;
}

Execution Plan:

2018-09-03 19:32:0= 3,098 232176 [pub-#78%springDataNode%] INFO=C2=A0 c.q.a.g.d.IpContainerIpV4= DataGridDaoImpl - SELECT
=C2=A0=C2=A0=C2=A0 __Z0.ID AS __C0_0,
=C2=A0=C2=A0=C2=A0 __Z0.MODULEID A= S __C0_1,
=C2=A0=C2=A0=C2=A0 __Z0.IPEND AS __C0_2,
=C2=A0=C2=A0=C2=A0= __Z0.IPSTART AS __C0_3
FROM IP_CONTAINER_IPV4_CACHE.IPCONTAINERIPV4DATA= __Z0 USE INDEX (IP_CONTAINER_IPV4_IDX1)
=C2=A0=C2=A0=C2=A0 /* IP_CONTAI= NER_IPV4_CACHE.IP_CONTAINER_IPV4_IDX1: SUBSCRIPTIONID =3D ?1
=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 AND MODULEID =3D ?2
=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0 AND IPSTART <=3D ?3
=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0 AND IPEND >=3D ?4
=C2=A0=C2=A0=C2=A0=C2=A0 */
W= HERE ((__Z0.SUBSCRIPTIONID =3D ?1)
=C2=A0=C2=A0=C2=A0 AND (__Z0.MODULEID= =3D ?2))
=C2=A0=C2=A0=C2=A0 AND ((__Z0.IPSTART <=3D ?3)
=C2=A0=C2= =A0=C2=A0 AND (__Z0.IPEND >=3D ?4))
2018-09-03 19:32:03,098 232176 [p= ub-#78%springDataNode%] INFO=C2=A0 c.q.a.g.d.IpContainerIpV4DataGridDaoImpl= - SELECT
=C2=A0=C2=A0=C2=A0 __Z1.ID AS __C1_0,
=C2=A0=C2=A0=C2=A0 __Z1.MODULEID AS __C1_1,
= =C2=A0=C2=A0=C2=A0 __Z1.IPEND AS __C1_2,
=C2=A0=C2=A0=C2=A0 __Z1.IPSTART= AS __C1_3
FROM IP_CONTAINER_IPV4_CACHE.IPCONTAINERIPV4DATA __Z1 USE IND= EX (IP_CONTAINER_IPV4_IDX1)
=C2=A0=C2=A0=C2=A0 /* IP_CONTAINER_IPV4_CACH= E.IP_CONTAINER_IPV4_IDX1: SUBSCRIPTIONID =3D ?5
=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0 AND MODULEID =3D ?6
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0 AND IPSTART <=3D ?7
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0 AND IPEND >=3D ?8
=C2=A0=C2=A0=C2=A0=C2=A0 */
WHERE ((__Z1.SUB= SCRIPTIONID =3D ?5)
=C2=A0=C2=A0=C2=A0 AND (__Z1.MODULEID =3D ?6))
= =C2=A0=C2=A0=C2=A0 AND ((__Z1.IPSTART <=3D ?7)
=C2=A0=C2=A0=C2=A0 AND= (__Z1.IPEND >=3D ?8))
2018-09-03 19:32:03,098 232176 [pub-#78%spring= DataNode%] INFO=C2=A0 c.q.a.g.d.IpContainerIpV4DataGridDaoImpl - SELECT
= =C2=A0=C2=A0=C2=A0 __Z2.ID A= S __C2_0,
=C2=A0=C2=A0=C2=A0 __Z2.MODULEID AS __C2_1,
=C2=A0=C2=A0=C2= =A0 __Z2.IPEND AS __C2_2,
=C2=A0=C2=A0=C2=A0 __Z2.IPSTART AS __C2_3
F= ROM IP_CONTAINER_IPV4_CACHE.IPCONTAINERIPV4DATA __Z2 USE INDEX (IP_CONTAINE= R_IPV4_IDX1)
=C2=A0=C2=A0=C2=A0 /* IP_CONTAINER_IPV4_CACHE.IP_CONTAINER_= IPV4_IDX1: SUBSCRIPTIONID =3D ?9
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0 AND MODULEID =3D ?10
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 AND = IPSTART >=3D ?11
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 AND IPEND= <=3D ?12
=C2=A0=C2=A0=C2=A0=C2=A0 */
WHERE ((__Z2.SUBSCRIPTIONID = =3D ?9)
=C2=A0=C2=A0=C2=A0 AND (__Z2.MODULEID =3D ?10))
=C2=A0=C2=A0= =C2=A0 AND ((__Z2.IPSTART >=3D ?11)
=C2=A0=C2=A0=C2=A0 AND (__Z2.IPEN= D <=3D ?12))
2018-09-03 19:32:03,098 232176 [pub-#78%springDataNode%]= INFO=C2=A0 c.q.a.g.d.IpContainerIpV4DataGridDaoImpl - ((SELECT
=C2=A0= =C2=A0=C2=A0 __C0_0 AS ID,
=C2=A0=C2=A0=C2=A0 __C0_1 AS MODULEID,
=C2= =A0=C2=A0=C2=A0 __C0_2 AS IPEND,
=C2=A0=C2=A0=C2=A0 __C0_3 AS IPSTARTFROM PUBLIC.__T0
=C2=A0=C2=A0=C2=A0 /* IP_CONTAINER_IPV4_CACHE."me= rge_scan" */)
UNION ALL
(SELECT
=C2=A0=C2=A0=C2=A0 __C1_0 AS = ID,
=C2=A0=C2=A0=C2=A0 __C1_1 AS MODULEID,
=C2=A0=C2=A0=C2=A0 __C1_2 = AS IPEND,
=C2=A0=C2=A0=C2=A0 __C1_3 AS IPSTART
FROM PUBLIC.__T1
= =C2=A0=C2=A0=C2=A0 /* IP_CONTAINER_IPV4_CACHE."merge_scan" */))UNION ALL
(SELECT
=C2=A0=C2=A0=C2=A0 __C2_0 AS ID,
=C2=A0=C2=A0= =C2=A0 __C2_1 AS MODULEID,
=C2=A0=C2=A0=C2=A0 __C2_2 AS IPEND,
=C2=A0= =C2=A0=C2=A0 __C2_3 AS IPSTART
FROM PUBLIC.__T2
=C2=A0=C2=A0=C2=A0 /*= IP_CONTAINER_IPV4_CACHE."merge_scan" */)




--
Best regards,
Andrey V. Mashenkov
--000000000000f7efea0575079416--