I have four tables, each contain a lakh of records. I need to transfer the records from those four tables to another four tables.
The first table is the primary table. The second and fourth tables are its secondary tables. The third table is a secondary table to the second table. Should I do it using a PL/SQL procedure?
I used four cursors for each and populate the data, but it was very slow. I want to increase the performance. How to do it?
I have one simple mantra that really helps when it comes to performance of database operations. It goes as follows:
- If it can be done with straight SQL statements, do it with SQL.
- If it can't be done with straight SQL, then use PL/SQL.
- If it can't be done with PL/SQL, then use Java in the database.
- If it can't be done with Java in the database, then use a C++ external procedure or something outside of the database.
For More Information
- Dozens more answers to tough Oracle questions from Brian Peasland are available.
- The Best Oracle Web Links: tips, tutorials, scripts, and more.
- Have an Oracle or SQL tip to offer your fellow DBAs and developers? The best tips submitted will receive a cool prize. Submit your tip today!
- Ask your technical Oracle and SQL questions -- or help out your peers by answering them -- in our live discussion forums.
- Ask the Experts yourself: Our SQL, database design, Oracle, SQL Server, DB2, metadata, object-oriented and data warehousing gurus are waiting to answer your toughest questions.
Dig deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.