Re: Direct particular index use as like oracle

Поиск
Список
Период
Сортировка
От Avinash Vallarapu
Тема Re: Direct particular index use as like oracle
Дата
Msg-id CAN0Tujcf48xcPZwOcYK+1_Hj9bsMVCHHjV_eBk1ibe7xY_ZL6g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Direct particular index use as like oracle  (Sathish Reddy <sathishreddy.postgresql@gmail.com>)
Список pgsql-admin
Дерево обсуждения
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 по дате отправления: