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 1szEdH-004y8W-3m for pgsql-admin@arkaria.postgresql.org; Fri, 11 Oct 2024 12:20:35 +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 1szEdE-002x31-Kw for pgsql-admin@arkaria.postgresql.org; Fri, 11 Oct 2024 12:20:33 +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 1szEdE-002x2t-9V for pgsql-admin@lists.postgresql.org; Fri, 11 Oct 2024 12:20:32 +0000 Received: from mail-qt1-x835.google.com ([2607:f8b0:4864:20::835]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1szEd6-000VmL-Vq for pgsql-admin@lists.postgresql.org; Fri, 11 Oct 2024 12:20:32 +0000 Received: by mail-qt1-x835.google.com with SMTP id d75a77b69052e-46042ee22a7so14519461cf.0 for ; Fri, 11 Oct 2024 05:20:25 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1728649224; x=1729254024; 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=9yjsGErCSs+q3E6rdnqomxpdV+7F6OA0NA20G18rSCU=; b=WUjAKR9UWQmpzL8Ckm63NKnByRVIUOzTAzgI9NDUAQKFq4L1RyikDT+BYf3ETUjfTF ki30NRg1nAW2xw9rylY5DpGIYlOUmfXZlv24SpPCVR34tLw59WrsEcSqZMtFGQyT4cbT FNw87u091/nj0iH2E/cGJEyIXyFiDUC2cC3s+sUbuAm+WALmSODo43/YN1KKkqSZsRRj pRvzdOIMG3pDe75+QLeAtV/y7RK6f+ExKvIC2zxtdTjKwNhCgvIhEYcKb2XYNjQ5esmj vuyEEYc6HAlSqh+nBRi8TZplt7czjPTAI/say471y6EuZTIki6I/6nCjucnBC/pm2naj Ejqg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1728649224; x=1729254024; 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=9yjsGErCSs+q3E6rdnqomxpdV+7F6OA0NA20G18rSCU=; b=Ax2MGDpZlNTGrANVQoK54M+BOajVGsmmLuJ0VJh/v2RIE+dWnAp01zwXUJxDJlaN6U 8RFG3hW+nCNhTnG8WG+ths5WF1/V/n+AT93UiQ2ipnFBueMdnCLyur2mCcJIWFM2d7ie DjUwCcD4wf4YKlLg5l5r9BSnN6cX/rJkNKBYfqR0kG4OlNga5zIj/h86a+iT3BqiKLcE QTGvOlqeQc9kZBYXjwvFEJJyVhnOuQflehZdop6o6UYIjP7m2zzOXD36rpJxuliW+VqS MsRCPWj4+mqma81O/4928I+AedcmJetuj9eojYxJdOc6gyOnX3eUofl/qH/W1vkZrGJU uXJA== X-Gm-Message-State: AOJu0YwUMFDx0gIL4KKWD7krXr0YMl29OfS2UGrWJU6gcIACPc6hIT/U GdiPwjg+f/E1JgG5HOvw83Fx89RU8OE83ps3az8ssHEzsX97tJcCFzCJUdH+tvMeDlLqx85eas5 c8OdFkT1XGJMJcnQadxp7y+ZfoUSTZ1V+LrxqNA== X-Google-Smtp-Source: AGHT+IHyd2X3yGES4aN6moDO7oJCu6LXwpWCeSkNXLYLgghwS+DuZQITIVLOk1/e2fIppkeg5/dZ/XWu6wBcfQEVdiM= X-Received: by 2002:a05:6214:5bc6:b0:6cb:ec42:8b40 with SMTP id 6a1803df08f44-6cbf00f952fmr27597786d6.41.1728649224105; Fri, 11 Oct 2024 05:20:24 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Avinash Vallarapu Date: Fri, 11 Oct 2024 16:20:12 +0400 Message-ID: Subject: Re: Direct particular index use as like oracle To: Sathish Reddy Cc: pgsql-admin Content-Type: multipart/alternative; boundary="000000000000f1b78e06243282b2" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000f1b78e06243282b2 Content-Type: text/plain; charset="UTF-8" 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 > --000000000000f1b78e06243282b2 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi,=C2=A0

On Fri, Oct 11, 2024, 2:59 PM Sathish Reddy &= lt;sathishreddy.postgr= esql@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 gettin= g 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 ?=C2=A0

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



Thanks=C2=A0
Sathish Reddy=C2=A0


Regards,
Avi.=C2=A0

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

--000000000000f1b78e06243282b2--