Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1szEhc-004yUj-4o for pgsql-admin@arkaria.postgresql.org; Fri, 11 Oct 2024 12:25:04 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1szEha-0033ye-C2 for pgsql-admin@arkaria.postgresql.org; Fri, 11 Oct 2024 12:25:02 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1szEha-0033yV-0S for pgsql-admin@lists.postgresql.org; Fri, 11 Oct 2024 12:25:02 +0000 Received: from mail-oa1-x30.google.com ([2001:4860:4864:20::30]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1szEhW-000VoG-MW for pgsql-admin@lists.postgresql.org; Fri, 11 Oct 2024 12:25:01 +0000 Received: by mail-oa1-x30.google.com with SMTP id 586e51a60fabf-2884e7fad77so1099762fac.2 for ; Fri, 11 Oct 2024 05:24:59 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1728649498; x=1729254298; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=9rkkyV+XNh4BSzOdYRntvEmq0UDbmaGFY9bX8wpPtgs=; b=d0KolAumiNs7t2Uhx5ZiyXGTt6CcupqTjs9BkfhCan4Khn0afIlMkg1ss5jtZX/9Nc sT4PChr1KCTdyU99Ur1CeGTjQU70NdKtOd3cOgrBxe7zNRnqhiWm3zD3nmrW3Qm8OLaU /WD9qtoeKOcNwzR56wjC+A+ATdblWJc9MQ1ETffdc9gUNZOwD0Ii1W/p9NZwfQnGeTUz rpvuNW+2ZdUS/PIDrB7PoGUweq5ckz/xMraNHXpE5X48DqlOXpTIWOZ6y+D4AFvOngKd WQw7wAzH+39Hn+/szKatvmYHXU0tTCp12EwtkM16HX4sf6Ax8qxSxkQ5z2dKytruyQAH 3XKQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1728649498; x=1729254298; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=9rkkyV+XNh4BSzOdYRntvEmq0UDbmaGFY9bX8wpPtgs=; b=AlGbHkZ91llCJtOWN7ZJ3hon+IMkHZRStWLgiDECLKuK/SYVKo+3vwb0nCPHm2EuXi Kt6AHipvxg0NJPpXPn5dFiP4rv4RBPC4Hj3wa5jdpC6+t0QvuChQ7yS4IfFPQiPnJWbq SqO0YrQq0lMcipBz8ixKdZnzpkKWVrOsHPeyQdk+pRzPv+H5DoYKK5Lfxr3ofkVKAV9b D45r0ae9nDi6TJ7avIxYwisLGt1c8e761GI1bfik6e+ci+CBBdCltY0SDzKd1hJNAR82 51RcAG4LSGzdn2XgJeMfAwm3qFEM7QlDdARDDYpb1DTTLFOyPIcU81of8N87hJhvyc6z kxwQ== X-Gm-Message-State: AOJu0YyepZap+RMdr79nF8lejLT1RzhFoP8AZpfnqOEj92k9C1uMVT+d o/36OFGzq7WmaT6VSWkORM9GzKNsAH6UHc01D7ifso4FiHCxZXKM8OU7Pr02n7TGLJgUXdRIQJJ PhgevYZhqpeLZNzyQKUWj7m5BEUE= X-Google-Smtp-Source: AGHT+IGF1AIgkMDhxZQ8w7AHxU2bEKIKaZP5I42wG14lsgk5n1ujLl0ar8/O2RqmMvnbxFkY1OyzCUAVAiVLGunuU3c= X-Received: by 2002:a05:6870:808b:b0:27b:5a02:f940 with SMTP id 586e51a60fabf-2886de38896mr1316189fac.23.1728649497953; Fri, 11 Oct 2024 05:24:57 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Sathish Reddy Date: Fri, 11 Oct 2024 17:54:45 +0530 Message-ID: Subject: Re: Direct particular index use as like oracle To: Avinash Vallarapu Cc: pgsql-admin Content-Type: multipart/alternative; boundary="0000000000004450060624329301" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000004450060624329301 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Yes, that is correct. On Fri, Oct 11, 2024, 5:50=E2=80=AFPM Avinash Vallarapu wrote: > Hi, > > On Fri, Oct 11, 2024, 2:59 PM Sathish Reddy < > sathishreddy.postgresql@gmail.com> wrote: > >> Hi >> We see direct use particular index in oracle.same we are trying to use >> in postgres.but every time we ae getting failed.please help us. >> > Do you mean that you don't see an Index being considered by planner in > Postgres, whereas a similar index is used in Oracle ? > > If the above is yes, can you provide some more information? > > >> >> Thanks >> Sathish Reddy >> > > > Regards, > Avi. > > Try HexaRocket today for your Oracle to PostgreSQL Migrations. > > www.hexarocket.com > >> --0000000000004450060624329301 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable

Yes, that is correct.


On Fri= , Oct 11, 2024, 5:50=E2=80=AFPM Avinash Vallarapu <avinash.vallarapu@gmail.com> wrote:
Hi,=C2=A0

<= div class=3D"gmail_quote">
On Fri, Oct= 11, 2024, 2:59 PM Sathish Reddy <sathishreddy.postgresql= @gmail.com> wrote:
Hi
=C2=A0 We see direct use particular index in = oracle.same we are trying to use in postgres.but every time we ae getting f= ailed.please help us.
Do you mean that you don't see an Index being considered by planner in= Postgres, whereas a similar index is used in Oracle ?=C2=A0

If the above is yes, can you provide = some more=C2=A0information?



Thanks=C2=A0
Sathish Reddy=C2=A0


Regards,
Avi.=C2=A0

Try HexaRocket today for your Oracle= to PostgreSQL Migrations.=C2=A0

--0000000000004450060624329301--