public inbox for [email protected]
help / color / mirror / Atom feedFrom: Avinash Vallarapu <[email protected]>
To: Sathish Reddy <[email protected]>
Cc: pgsql-admin <[email protected]>
Subject: Re: Direct particular index use as like oracle
Date: Fri, 11 Oct 2024 16:35:44 +0400
Message-ID: <CAN0Tujcf48xcPZwOcYK+1_Hj9bsMVCHHjV_eBk1ibe7xY_ZL6g@mail.gmail.com> (raw)
In-Reply-To: <CA+M9Y+Afmiz=HkSALJmumZjn9L_J4Mf1aB46YUtOLOOoQavVYA@mail.gmail.com>
References: <CA+M9Y+A3Wi5RMuHqtMkjJ2foeExEGOi9_uBS_RRdDa1xUPbmFw@mail.gmail.com>
<CAN0TujfB4HK0C0Lu1MEnr4Z_X6rCKOqgYCWZ+HfT9rMGe40WiQ@mail.gmail.com>
<CA+M9Y+Afmiz=HkSALJmumZjn9L_J4Mf1aB46YUtOLOOoQavVYA@mail.gmail.com>
Hi,
On Fri, Oct 11, 2024, 4:24 PM Sathish Reddy <
[email protected]> 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 <[email protected]>
> wrote:
>
>> Hi,
>>
>> On Fri, Oct 11, 2024, 2:59 PM Sathish Reddy <
>> [email protected]> 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
>>
>>>
view thread (6+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: Direct particular index use as like oracle
In-Reply-To: <CAN0Tujcf48xcPZwOcYK+1_Hj9bsMVCHHjV_eBk1ibe7xY_ZL6g@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox