Search: [Oracle] - Anayrat links

Migrate date functions from Oracle to Amazon RDS for PostgreSQL | AWS Database Blog

PostgreSQL · Migration · Oracle

January 4, 2024 at 11:08:25 AM GMT+1 * · permalink

https://aws.amazon.com/blogs/database/migrate-date-functions-from-oracle-to-amazon-rds-for-postgresql/

GitHub - microsoft/DataMigrationTeam: Repository for the Data Migration Team

Oracle · PostgreSQL · Migration · MSQLServer

March 2, 2021 at 4:29:29 PM GMT+1 * · permalink

https://github.com/microsoft/DataMigrationTeam

Migrating database storage objects from Oracle to Postgres - Microsoft Tech Community

Migration · PostgreSQL · Oracle

February 26, 2021 at 5:51:01 PM GMT+1 * · permalink

https://techcommunity.microsoft.com/t5/azure-database-for-postgresql/migrating-database-storage-objects-from-oracle-to-postgres/ba-p/2117312

Fetch First Rows Just Got Faster | Oracle Optimizer Blog

SQL · Oracle · limit

September 27, 2018 at 1:29:00 PM GMT+2 * · permalink

https://blogs.oracle.com/optimizer/fetch-first-rows-just-got-faster

Index skip scan | Oracle Scratchpad

Oracle · sql · skip · not_read

June 4, 2018 at 9:35:41 AM GMT+2 * · permalink

https://jonathanlewis.wordpress.com/category/oracle/indexing/index-skip-scan/

Oracle. Tuning the Buffer Cache

Oracle · Internal

April 30, 2018 at 4:12:15 PM GMT+2 * · permalink

http://slideplayer.com/slide/4002724/

Oracle on VMware

Oracle · vmware · numa

December 22, 2017 at 11:21:30 AM GMT+1 * · permalink

https://www.performing-databases.com/wp-content/uploads/2017/12/Klier-Oracle-on-VMware.pdf

How do UPSERT and MERGE work in Oracle, SQL Server, PostgreSQL and MySQL | Vlad Mihalcea's Blog

PostgreSQL · SQL · Oracle

November 9, 2017 at 4:12:51 PM GMT+1 * · permalink

https://vladmihalcea.com/2017/11/06/how-do-upsert-and-merge-work-in-oracle-sql-server-postgresql-and-mysql/

Partition-wise join | Learning is not a spectator sport

Oracle · partionning

September 28, 2017 at 4:48:50 PM GMT+2 * · permalink

https://connor-mcdonald.com/2017/09/21/partition-wise-join/

ORACLE-BASE - Filtered Partition Maintenance Operations in Oracle Database 12c Release 2 (12.2)

Oracle · partionning

September 12, 2017 at 9:07:25 PM GMT+2 * · permalink

https://oracle-base.com/articles/12c/filtered-partition-maintenance-operations-12cr2

ORACLE-BASE - Partitioned External Tables in Oracle Database 12c Release 2 (12.2)

Oracle · partionning

September 11, 2017 at 8:50:20 AM GMT+2 * · permalink

https://oracle-base.com/articles/12c/partitioned-external-tables-12cr2

ORACLE-BASE - Read-Only Partitions and Subpartitions in Oracle Database 12c Release 2 (12.2)

Oracle · partionning

September 11, 2017 at 8:50:06 AM GMT+2 * · permalink

https://oracle-base.com/articles/12c/read-only-partitions-and-subpartitions-12cr2

ORACLE-BASE - Multi-Column List Partitioning in Oracle Database 12c Release 2 (12.2)

Oracle · partionning

September 9, 2017 at 10:47:24 PM GMT+2 * · permalink

https://oracle-base.com/articles/12c/multi-column-list-partitioning-12cr2

JOIN Elimination: An Essential Optimiser Feature for Advanced SQL Usage – Java, SQL and jOOQ.

SQL · MySQL · Oracle · MSQLServer · DB2 · PostgreSQL · Performance

September 1, 2017 at 5:00:25 PM GMT+2 * · permalink

https://blog.jooq.org/2017/09/01/join-elimination-an-essential-optimiser-feature-for-advanced-sql-usage/

ORACLE-BASE - Optimizer Statistics Advisor in Oracle Database 12c Release 2 (12.2)

Oracle · Statistics

August 27, 2017 at 3:10:58 PM GMT+2 * · permalink

https://oracle-base.com/articles/12c/optimizer-statistics-advisor-12cr2

Postgres vs. Oracle access paths XI - Sample Scan - Blog dbi services

Oracle · PostgreSQL · Tablesample

August 27, 2017 at 2:57:49 PM GMT+2 * · permalink

https://blog.dbi-services.com/postgres-vs-oracle-access-paths-xi/

Postgres vs. Oracle access paths IX - Tid Scan - Blog dbi services

PostgreSQL · Oracle

August 25, 2017 at 7:00:28 PM GMT+2 * · permalink

https://blog.dbi-services.com/postgres-vs-oracle-access-paths-ix/

Postgres vs. Oracle access paths X - Update - Blog dbi services

PostgreSQL · Oracle

August 25, 2017 at 6:59:28 PM GMT+2 * · permalink

https://blog.dbi-services.com/postgres-vs-oracle-access-paths-x-update/

Postgres vs. Oracle access paths VIII - Index Scan and Filter - Blog dbi services

Oracle · PostgreSQL · index

August 21, 2017 at 11:14:28 AM GMT+2 * · permalink

https://blog.dbi-services.com/postgres-vs-oracle-access-paths-viii/

Postgres vs. Oracle access paths VII - Bitmap Index Scan - Blog dbi services

PostgreSQL · Oracle · index

August 21, 2017 at 11:12:11 AM GMT+2 * · permalink

https://blog.dbi-services.com/postgres-vs-oracle-access-paths-vii/