How can you performance tune your database?, JAVA Programming

1. De normalizes your tables where required.

2. Proper use of index columns: An index based on numeric parts is more efficient than an index based on character columns.

3. Replace the number of columns that build up a composite key.

4. Proper partitioning of tablespaces and makes a special tablespace for special data types like CLOB, BLOB etc.

5. Data access performance can be tuned by using stored procedures or macros to crunch data in the database server to replace the network overhead and also caching data within your application to reduce the number of accesses.

 

Posted Date: 7/27/2012 4:49:30 AM | Location : United States







Related Discussions:- How can you performance tune your database?, Assignment Help, Ask Question on How can you performance tune your database?, Get Answer, Expert's Help, How can you performance tune your database? Discussions

Write discussion on How can you performance tune your database?
Your posts are moderated
Related Questions
Required: Inventory Selection Function in Opentaps ERP We work on Opentaps ERP and Application development framework. Our requirement is to modify the Inventory selection functi

? • ?read from a file a series of an infix algebraic expressions comprised of constant and variable operands (integers), operands (%, *, /, +, -) and parenthesis. Two slashes (//)


What 'System.out.println()' signifies? 'System' is a predefined class. System class gives access to the system. 'out' is the output stream. 'println' is printin

What happens to the static fields of a class during serialization? There are three exceptions in which serialization does not necessarily read and write to the stream. These


What is the function of Network Interface Card? NIC is an I/O device which plugs within the computer and it enables it to communicate over a network.

You need to build an agent system using the JADE Toolkit that allows the lecturer of FIT5031 to broadcast their availability and arrange for consultation with students in a dynamic

A for loop repeats until a specified condition evaluates to false. For for loop the JavaScript is similar to the Java and C for loops. A for statement looks as:  for ([initial-

can you explain me the er diagram for the online doctor system