Community Tips

SORA regularly publishes community tips! – If you have a tip you want to share, click on the button on the right!

Submit Community Tip

swissouc

👩‍💻 SORA's Tip #100 Database design flaw

👩‍💻 SORA's Tip #100

Database design flaws will have an impact on its performance!

#SwissOUC #CommunityTips

👩‍💻 SORA's Tip #99 Remember that SYSDATE

👩‍💻 SORA's Tip #99

Remember that SYSDATE returns the time and date of your DBs operating system!

#SwissOUC #CommunityTips

👩‍💻 SORA's Tip #98 If you do not have ref

👩‍💻 SORA's Tip #98

If you do not have referential integrity enforced within the database you have almost certainly got damaged data.

#SwissOUC #CommunityTips

👩‍💻 SORA's Tip #97 If your data is import

👩‍💻 SORA's Tip #97

If your data is important to you then you need to design your database: having an ERD is fundamental.

#SwissOUC #CommunityTips

👩‍💻 SORA's Tip #96 Performance tuning yo

👩‍💻 SORA's Tip #96

Performance tuning your database without an ERD is like trying to drive a car by steering with your knees.

#SwissOUC #CommunityTips

👩‍💻 SORA's Tip #95 If you have no ERD, do

👩‍💻 SORA's Tip #95

If you have no ERD, do you really know your data?

#SwissOUC #CommunityTips

👩‍💻 SORA's Tip #94 Brook's Law (1975) sti

👩‍💻 SORA's Tip #94

Brook's Law (1975) still applies today: "Adding manpower to a late software project makes it even later."

#SwissOUC #CommunityTips

👩‍💻 SORA's Tip #93 Stop using parameter S

👩‍💻 SORA's Tip #93

Stop using parameter SERVICE_NAMES as it is deprecated. Use DBMS_SERVICE package or srvctl CLI instead.

#SwissOUC #CommunityTips

👩‍💻SORA's Tip #92 PDB default service sho

👩‍💻SORA's Tip #92

PDB default service should only be used for administrative tasks.

#SwissOUC #CommunityTips

👩‍💻 SORA's Tip #91 Always specify the col

👩‍💻 SORA's Tip #91

Always specify the columns in INSERT statements!

#SwissOUC #CommunityTips

👩‍💻SORA's Tip #90 The WHERE-clause filter

👩‍💻SORA's Tip #90

The WHERE-clause filters data before aggregations are applied. To filter aggregationsuse the HAVING clause.

#SwissOUC #CommunityTips

👩‍💻SORA's Tip #89 Table aliases can help

👩‍💻SORA's Tip #89

Table aliases can help you write less when doing JOINS, they also improve your codes readability.

#SwissOUC #CommunityTips

👩‍💻SORA's Tip #88 Instead of using long d

👩‍💻SORA's Tip #88

Instead of using long data value lists in your IN keyword, think about if you can solve it with a JOIN.

#SwissOUC #CommunityTips

👩‍💻SORA's Tip #87 Avoid WHERE clauses wit

👩‍💻SORA's Tip #87

Avoid WHERE clauses with functions when writing SQL statements.

#SwissOUC #CommunityTips

👩‍💻SORA's Tip #86 Do one change at a time

👩‍💻SORA's Tip #86

Do one change at a time - don't change multiple things at once.

#SwissOUC #CommunityTips

👩‍💻SORA's Tip #85 After applying a patch

👩‍💻SORA's Tip #85

After applying a patch to your database verify if your performance workarounds are still required (e.g. Hints, Profiles).

#SwissOUC #CommunityTips

SORA's Tip #84 If you start fixing a broken syste

SORA's Tip #84

If you start fixing a broken system, take a backup of the broken system first.

#SwissOUC #CommunityTips

SORA's Tip #83 Agree on a set of coding guideline

SORA's Tip #83

Agree on a set of coding guidelines with your team.

#SwissOUC #CommunityTips

SORA's Tip #82 Write down the things you learn!

SORA's Tip #82

Write down the things you learn!

#SwissOUC #CommunityTips

SORA's Tip #81 Make sure Grants and Synonyms are

SORA's Tip #81

Make sure Grants and Synonyms are created after deploying changes!

#SwissOUC #CommunityTips #sql

Load More... Follow on Instagram

Meet SORA

Subscribe