Hello,
My Application is very slow.I am sure that this is the problem of
indexes in the databases.
We are not creating the foreignkey reference.So the index is not
created for the Referenced table.
We asked our DBA to create the Index and he created Secondary
indexes.Now it is lit bit o.k.
But still some tables are not having the indexes.This is my
query.When i test this query in
the volume testing,it is taking 5 minutes to fetch the records.

SELECT DISTINCT A.LCL_KEY FROM AccUnit A,
BATCHDTL BD WHERE
A.ARRANGEMENTID=BD.ARRANGEMENTID ORDER BY A.LCL_KEY

SELECT DISTINCT A.GRP_RCON_KEY FROM ACCUnit A,
BATCHDTL BD WHERE A.ARRG_ID=B.ARRG_ID
ORDER BY A.GRP_RCON_KEY

There Arrangementid field in both AccUnit and BatchDtl table is not
having the seperate index.But we have the composite key for three
fields in the AccUnit table.One field is Arrangementid.
If we create index for this field in these two tables, will it be
fast?
I have to give the proper explanation before send the request to DBA
for
creating indexes.I don't know more about indexes.


Thanks in Advance..

Sivarman