Oracle, PostgreSQL Postgres vs. Oracle access paths – intro 01.08.2017 by Oracle Team By Franck Pachot . This is the start of a series on PostgreSQL execution plans, access path, join methods, hints and execution statistics. The approach will compare Postgres and Oracle. It is not a comparison to see which one is(…)
PostgreSQL PostgreSQL on Cygwin 01.08.2017 by Oracle Team By Franck Pachot . I run my laptop with Windows 10 for office programs, and VirtualBox machines with Linux for the big stuff (Oracle databases). I have also Cygwin installed on Windows for GNU programs. I wanted to quickly install(…)
Oracle, PostgreSQL Postgres vs. Oracle access paths VII – Bitmap Index Scan 31.07.2017 by Oracle Team By Franck Pachot . In the previous post we have seen the Index Scan, where a where clause condition uses the index structure to find rows and then fetches remaining columns from the table. The case(…)