1. Never Mix Data Types
2. Avoid Like Predicate
3. Avoid use of functions in column which appears in JOIN or WHERE clause
4. Use appropriate data type and size
5. Avoid UPDATE as far as possible.
6. Avoid sub-queries whenever it is possible
• EXISTS and IN sub-queries can be converted to INNER JOINs.
• NOT EXISTS and NOT IN sub-queries can be converted to OUTER JOINs
7. Take advantage of PL/SQL-specific enhancements for SQL:
• BULK COLLECT and FORALL, cursor variables, table functions
8. Proper Indexing
9. Always use table aliases when referencing columns.
10. Use ANSI JOINS in contrast to ‘Traditional’ JOINS
11. Take advantage of MERGE
12. Take advantage of INSERT ALL/FIRST
13. Gather statistics
14. Usage of hints
15. Pin table to memory
16. Global Temporary Table
17. Materialized View
18. Reduce volume of data
• Creating small intermediate tables with or without applying some business logic.
• Implementing Partitioning feature to achieve partition pruning and preventing Full table scan.
19. Hit aggregated data
20. Re-use of intermediate table
your blog is helping in my studies thank you sql and pl sql Online course
ReplyDeletePerde Modelleri
ReplyDeletemobil onay
mobil ödeme bozdurma
HTTPS://NFTNASİLALİNİR.COM
ankara evden eve nakliyat
trafik sigortası
dedektör
Websitesi Kurma
Aşk romanları
smm panel
ReplyDeletesmm panel
İŞ İLANLARI
İNSTAGRAM TAKİPÇİ SATIN AL
hirdavatciburada.com
www.beyazesyateknikservisi.com.tr
SERVİS
Tiktok Para Hilesi İndir
ataşehir beko klima servisi
ReplyDeletetuzla lg klima servisi
çekmeköy toshiba klima servisi
ataşehir toshiba klima servisi
maltepe lg klima servisi
kadıköy lg klima servisi
maltepe alarko carrier klima servisi
kadıköy alarko carrier klima servisi
maltepe daikin klima servisi
Good content. You write beautiful things.
ReplyDeletehacklink
sportsbet
sportsbet
korsan taksi
hacklink
mrbahis
vbet
mrbahis
taksi
dijital kartvizit
ReplyDeletereferans kimliği nedir
binance referans kodu
referans kimliği nedir
bitcoin nasıl alınır
resimli magnet
L0SJX