Postgres Pro
Downloads
Home   >   mailing lists

Re: Direct particular index use as like oracle - Mailing list pgsql-admin

From Avinash Vallarapu
Subject Re: Direct particular index use as like oracle
Date
Msg-id CAN0Tujcf48xcPZwOcYK+1_Hj9bsMVCHHjV_eBk1ibe7xY_ZL6g@mail.gmail.com
Whole thread Raw
In response to Re: Direct particular index use as like oracle  (Sathish Reddy <sathishreddy.postgresql@gmail.com>)
List pgsql-admin
Tree view
Hi, 

On Fri, Oct 11, 2024, 4:24 PM Sathish Reddy <sathishreddy.postgresql@gmail.com> wrote:

Yes, that is correct.

Okay. You might have to provide some more information to get more help such as, the SQL, it's Query Plan and Table DDL.

If you have migrated this table from Oracle, you might have to perform a Vacuum Analyze on this table before you try anything.

Vacuum analyze <table>;


On Fri, Oct 11, 2024, 5:50 PM Avinash Vallarapu <avinash.vallarapu@gmail.com> 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. 

pgsql-admin by date:

Previous
From: Sathish Reddy
Date:
Subject: Re: Direct particular index use as like oracle
Next
From: Keith
Date:
Subject: Re: Direct particular index use as like oracle