GeekArticles
FAQ
Oracle FAQ
FAQ
Oracle FAQSQL best practises
While writing SQL in oracle 10g
1) Should we ensure the joins are the first in where clause i.e
where a.table1=b.table2
and a.table1=:b
2) Is there a thumb rule that says in all cases bind varibles queries will give faster results than...
Sponsored Links
Read Next: Performance Bottleneck
Related Topics
Subscribe via RSS
Oracle FAQ
- Synchronize data from remote location
- Oracle Fundamentals
- How to connect SQLPlus without tnsnames.ora
- Best Practices for App Server Keep Alive
- bind variables in triggers
- how to avoid outer joins
- One 900 column table versus ten 90 column tables.
- Does select generate undo ?
- Performance Question
- Help analyze statspack report
