| Sumit |
Posted: Nov 23, 2005 01:22:47 AM |
Total Post: 1
Joined: Nov, 2005
|
Hello,
I am working on a bank application where tables contains arround 3 or 4 millions records. I am using Java as frontend. All updated are done through plsql stored procedures. Please tell me, which technics should i use for achiving the best performace. Should i not use constrants like foreign key?
Sumit |
|
|
 Vigyan |
| Posted: Dec 01, 2005 12:01:54 PM |  |
|
Total Post: 386
Joined: May, 2001
|
Update performance is impacted by constraints, indexes, trigger etc.. Do you update complete table or just certain records based on a where clause?
Vigyan
|
|
|
|
|
| Arulselvaraj |
| Posted: Jan 01, 2006 01:57:48 PM | |
|
Total Post: 15
Joined: Dec, 2005
|
Make sure your foreign key column is indexed and you collect statistics regularly.
|
|
|
|
|
| Kiran |
| Posted: Apr 07, 2006 01:27:57 AM | |
|
Total Post: 9
Joined: Apr, 2006
|
For Optimal Performance...
1) use Bind variables instead of Literals.
2) Avoid large anonymous blocks. if possible, upgrade these to packages or procedures.
3) use hints in SQL Queries
4) use indexes (check for lack of Access path)
5) use union All instead of UNION, use indexed column for order by, and if possible avoid sorts.
There are many more things. that we can take care.. if there is any particular issue, that you find a hurdle for optimal performance, then write that..
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
