June 4, 2010 5:30 PM. 18 attended.
DB Performance brick: SQL Access paths
Sydney Mechanics’ School of Arts (map)
Hello Everyone,
This meeting is part of performance development/tuning meetings. We started our performance related discussion with "101 Ways to get SQL Execution Plan" presentation. As a logical next step let discuss in details basis of any SQL plan's performance.
During this meeting we will discuss all possible ways Oracle can access data from a single table. We will make an overview of each possible way to access data and compare it with others
(FULL SCAN, ROWID, INDEX RANGE/UNIQUE/SKIP, IOT ...).
After this discussion you will refresh your understanding on several conceptual areas important for SQL performance turning including when it is more effective to use FULL scan as alternative to INDEX access, what you need to be aware about using ROWIDs and what advantage give us IOT structures, why Oracle Statistics plays an important role in this area.
As always you will find us staring from 17:30 with pizza and beer ready for you :)
Please join us and bring your Oracle colleagues to make our community even better.
Yury & Organizers
-
-
Paul GuerinCo-OrganizerThe new format works and I think everyone appreciated the value of the performance tips in the presentation.
-
-
-
-
-
Volodymyr ShatorkinHi. It was my first meetup with Sydney Oracle mates. I am glad I visited it because I listened questions which I would never ask to myself. It is like you discuss something at web forum but in real life – offline :)
-
-
-
-
-
-
-
-
-
-
Offer a perk for our members and get exposure.
Offer a perk →
People in thisMeetup are also in:
-
140 members
-
-
-
-
-
