Re: Direct particular index use as like oracle

Hi,

On Fri, Oct 11, 2024, 4:24 PM Sathish Reddy <
sathishreddy(dot)postgresql(at)gmail(dot)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(dot)vallarapu(at)gmail(dot)com>
> wrote:
>
>> Hi,
>>
>> On Fri, Oct 11, 2024, 2:59 PM Sathish Reddy <
>> sathishreddy(dot)postgresql(at)gmail(dot)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
>>
>>>