Sydney Oracle Meetup

DB Performance brick: SQL Access paths

Jun 4 Fri 5:30 PM

Location: Sydney Mechanics’ School of Arts

Level 1, 280 Pitt Street
Sydney 02 9262 7300

This is a private home or office

Attendance: 18 people attended.
4.508 (8 ratings)
Who organized?
Yury Velikanov

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

Photos of this Meetup

No photos yet.

Talk about this Meetup

You must be a member to post a comment. Join or login.

Who attended?

18 attendees
- Milton Ingram
  
  “ Great. Interesting stuff on access methods. ”
- Warwick Sands
  
  “ Well presented and informative. As always I learnt a few things. ”
- Sergey Porokh
  
  “ New format is really nice. ”
- Geoffrey Zhang
  
  “ Encourage further reading on details of the topic. ”
- Paul Guerin
  
  “ The new format works and I think everyone appreciated the value of the performance tips in the presentation. ”
- Volodymyr Shatorkin
  
  “ Hi. 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 :) ”
- Michael Carter
- Fiona
- Ilnaz Ziganshin
- Chris Hodgkins
- Gary Myers (+1 guest)
- Nuno Pinto do Souto
- Serge Stadnichenko
- Yury Velikanov
- Arun Birla
- nick patten
- Evgeny Platonov