SORA Magazine - Swiss Oracle User Community - SwissOUC
  • Home
  • Authors
  • Tip Cards
  • SwissOUC
  • Get in touch!
  • Become an Author!

Select Page

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
πŸ‘©β€πŸ’» 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
Follow on Instagram

Meet SORA

Hi, I'm SORA, the Swiss Oracle User Community mascot!

Subscribe

Be part of our community

Join our mailing list to receive the latest news and updates from our community.

You have Successfully Subscribed!

© Swiss Oracle User Community