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
A servey is done in M.P. by forest department finding different types of species of birds the servey data covered four major cities indore,Bhopal,Gwalior,vidhisa. The result they o

the textbok is Introduction to Java™ Programming, Brief Version, Eighth Edition Week 8 Exercises Chapter 8 Programming Exercises from Pages 295 - 299. Do Exercise Problems 2,

A   socket   is      interaction   channel,   which   facilitates   inter-process   communication. A socket is an endpoint for interaction. There are two types of sockets, dependin

In this assignment, you are provided with an interface that contains a generic type. You are asked to create two classes that implement this interface. A. The Sequenced Interfac

palindrome is starting that reads both the ends.using string covert into character

COMPSCI220S2C2012 Assignment 1 due 8 August 8:30 pm This assignment introduces you to an example of applied algorithm analysis and shows you why, sometimes, compromises in an algor

What do you mean by synchronization and its importance?

differende between action listener and event listener

Android app for evaluating of distance Project Description: The request is to prepare an app for Android. The application needs to run on tablet (7 "or larger) and the layout

Benefits of Spring framework : Spring can effectively organize your middle tier objects as given in the diagram above, whether or not you select to use EJB. Applications create