Re: Direct particular index use as like oracle

[Avinash Vallarapu <avinash.vallarapu@xxxxxxxxx>]

Hi, 

On Fri, Oct 11, 2024, 4:24 PM Sathish Reddy <sathishreddy.postgresql@xxxxxxxxx> 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@xxxxxxxxx> wrote:

Hi, 

On Fri, Oct 11, 2024, 2:59 PM Sathish Reddy <sathishreddy.postgresql@xxxxxxxxx> 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