Data Dictionary Performance – reference September 29, 2009Posted by mwidlake in internals, Perceptions.
Tags: data dictionary, perception, performance
I’ve got a couple more postings on Data Dictionary performance to get where I plan to go to with this, but if you want to deep-dive into far more technical details then go and check out Dion Cho’s excellent posting on fixed object indexes.
I was not planning on getting into the sys.x$ fixed objects as you need SYS access to look at them, which not everyone has, but this is where Dion goes. His posts are always good, I need to check them far more.
As a soft-technical aside, I often mention to people when doing courses on SQL or writing standards or even the odd occasions I’ve discussed perception, that we Westerners are taught to read from left to right, top-to-bottom and we pick out left justification very well. Code laid out like the below we find easy to read:
select pers.name1 surname ,pers.name2 first_forename ,pers.nameother middle_names ,peap.appdate appointment_date ,decode (addr.name_num_ind ,'N', to_char(addr.housenum) ,'V', addr.housename ,'B', to_char(addr.housenum ||' '||addr.housename) house_no_name ,addr.address2 addr_street ,addr.address3 addr_town ,addr.address4 addr_dist ,addr.code addr_code from person pers ,address addr ,person_appointments peap where pers.addr_id =addr.addr_uid and pers.pers_id =peap.pers_id and pers.active_fl ='Y' and pers.prim_cons ='ANDREWSDP' and peap.latest_fl ='Y'
But this is not true of other cultures, where people do not read left to right, top to bottom. I have had this confirmed just a couple of times when people who were born in Eastern cultures are in the course/conversation.
So I was very interested to see Dion’s Korean version of the blogpost I reference above (I really hope this link here to the korean version is stable).
The main body of the page is on the right, not left, but the text appears to be left justified.
Of course, I am horribly ignorant, I do not know which direction Koreans read in :-(. I could be spouting utter rubbish.