cargo-cult-programming

Why the most natural query(i.e. using INNER JOIN (instead of LEFT JOIN)) is very slow.

This query takes too long... explain analyze select c.company_rec_id, c.the_company_code , c.company from tlist t -- it is questionable why this query become fast when using left join, the most natural query is inner join... join mlist m using(mlist_rec_id) join parcel_application ord_app using(parcel_application_rec_id) join par...

How can I learn to program without understanding programming?

I have learned programming by both at recognized school and self-studying. If there's a sample, I can develop similar thing easily. But I don't understand any single purpose there. For example, I haven't learned and done any j2se coding & today at work, I have told to make a screen and validate and so on. I just studied the similar scre...