Solved

Using Database Indices Effectively in JAVA

Posted on 2008-06-12
3
162 Views
Last Modified: 2010-03-30
Hi Experts,

My application is built in Java and the back-end is Oracle Rally installed in a Thin Server. To maximize the performance, the Database is being indexed now.

I got little information from the DBA. He says it uses Sorted indices for range retrieval and hashed for direct look-up. He has also provided me the following information about the indices.

INSURED_INFO_0400_SORTED        with column WIP_NUMBER
                                and column LAST_NAME
                                and column MIDDLE_NAME
                                and column FIRST_NAME
                                and column SSN
                                and column BIRTH_DATE
 

INSURED_INFO_HASH               with column WIP_NUMBER
        in INSURED_INFO_AREA
*********This index is a placement index clustered with the data*************

INSURED_INFO_HASH_SSN           with column SSN
                                and column WIP_NUMBER
                                and column INSURED_SEQUENCE_CODE

 
INSURED_INFO_SORTED_001         with column LAST_NAME
                                and column FIRST_NAME
                                and column WIP_NUMBER


I would like to know, how effectively and efficiently we could make use of the indices in the Java application.

Please advice.

Thanks & Regards,
Madhu Manikandan, R
0
Comment
Question by:CIPL-Senthil
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 25

Expert Comment

by:Tomas Helgi Johannsson
ID: 21780070
     Hi!

If you want Oracle to use the indexes you create a sql query
where the columns of the indexes are used as the matching columns
in where clause of the sql query.

If Oracle ( or any other database) cannot match the sql where clause columns
to a index column it will use table scan instead of index scan.

Regards,
  Tomas Helgi
0
 

Author Comment

by:CIPL-Senthil
ID: 21784057
Our backend is ORACLE RALLY [OLD VERSION]. I would like to know whether the indices created in oracle rally could be used effectively in JAVA. If so, could you please provide an example?
0
 
LVL 25

Accepted Solution

by:
Tomas Helgi Johannsson earned 500 total points
ID: 21784748
     Hi!

It should not matter what version of Oracle or what database it is as long as the indexes match
the where clause columns as I said before.

Regards.
   Tomas Helgi
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Go is an acronym of golang, is a programming language developed Google in 2007. Go is a new language that is mostly in the C family, with significant input from Pascal/Modula/Oberon family. Hence Go arisen as low-level language with fast compilation…
Java functions are among the best things for programmers to work with as Java sites can be very easy to read and prepare. Java especially simplifies many processes in the coding industry as it helps integrate many forms of technology and different d…
Viewers will learn about arithmetic and Boolean expressions in Java and the logical operators used to create Boolean expressions. We will cover the symbols used for arithmetic expressions and define each logical operator and how to use them in Boole…
This tutorial explains how to use the VisualVM tool for the Java platform application. This video goes into detail on the Threads, Sampler, and Profiler tabs.

729 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question