Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Best practice query

Nic PilotNov 21 2021

Hi,
For a while I'm questioning myself about a best practice query for performance.
I've 2 tables.
EMPLOYEES and DEPARTMENTS
The EMPLOYEES table can contains millions of records.

Which query is better for performance ?

Query 1

Select t1.emp_id, t1.emp_name, t2.dept_name
from EMPLOYEES t1, DEPARTMENTS t2
where t1.dept_id = t2.dept_id
order by t1.emp_name

Query 2

Select emp_id, emp_name, (select mypackage.get_dept_name(dept_id) from dual) as dept_name
from EMPLOYEES
order by emp_name

Comments

EdStevens
cayenne wrote:
Hi Folks,
I just cannot seem to find anything readily in MOS at Oracle...

I understand that these days, the patches they put out are no longer just fixes to pieces of the database, but for some reason, they are now full blown installs.

So, rather than download from OTN and install and then have to patch...I'd rather go to MOS and download the patch and install that as my fresh database install.

My trouble is, I can't find the darned thing looking through the patch area, without knowing the patch number..etc.
I feel your pain and really can't offer any advice on that. Searching for patches has been a continual source of frustration for me.
What do ya'll do when wanting to find the latest version for a fresh install?

A further question..how are ya'll treating this new patch paradigm where they seem to expect you to do fresh installs just to patch up a level? Do you all have the resources to do a new install and migrate over...or do you migrate in place which the documentation seems to warn your off from doing?
Once you download the patch/full install and unzip it, look for the 'readme' files. The installer should detect or ask if you are doing a patch and handle the 'upgrade' conversion for you. At least it does when upgrading Grid Infrastructure. I'll find out about databases next week. ;-)

>
Thanks in advance,

cayenne
Srini Chavali-Oracle
Pl see these MOS Docs

Quick Reference to RDBMS Database Patchset Patch Numbers [ID 753736.1]
Quick Reference To Patch Numbers For Database PSU, SPU(CPU) And Bundle Patches [ID 1454618.1]

There are advantages to an out-of-place upgrade - you can install the software while the instance is up and running, thus limiting your downtime. It also allows for a quick downgrade if that should ever be needed.

Important Changes to Oracle Database Patch Sets Starting With 11.2.0.2 [ID 1189783.1]

HTH
Srini
Helios-GunesEROL
Hi;

Please also refer:
Oracle Recommended Patches -- Oracle Database [ID 756671.1]
NOTE:430449.1 - How to find DB Patches for the Microsoft Windows platforms My Oracle Support

Regard
Helios
1 - 3

Post Details

Added on Nov 21 2021
6 comments
281 views