[x]
Posted via EE Mobile

Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again.
Question
[x]
Attachment Details

Creating Index in Oracle

Asked by ram_trb in Oracle 10.x, Oracle SCM

Hi, am using index in oracle for performance, still its taking some time, can anyone suggest me some options to improve it.

I have four tables.
EMP_DETIALS        50000
EMPLOYEE            160000      
EMPMASTER          4000
EMPCODEDETAILS       4307000

I want to get records combining four tables with some criterias.. qry will be something like this

SELECT  DISTINCT(C.EMPID) FROM  EMPMASTER A,  EMPCODEDETAILS B, EMPLOYEE C, EMP_DETIALS D WHERE A.EMPMASTERID =  B.EMPMASTERID AND  B.EMPCODE = C.NDC  AND C.EMPID =  D.EMPID AND C.STATUS_FLAG ='A' AND A.EMPTYPE = 'EXECUTIVE'  AND A.EMPMASTERTYPE = 'EMP' AND A.STATUS=0 AND A.LISTDATE <= SYSDATE AND  LOWER(D.EMPNAME' '||D.EMPINTIAL||' '||D.EMPGRAGE) LIKE 'Doe%')

Can i write some inner qrys but tat too taking some time..

Please advice me..

Thank you

      
 
Related Solutions
Keywords: Creating Index in Oracle
Title
1 SQL Error ORA-01427 -- Help t…
2 query performance degrade
 
Loading Advertisement...
 
[+][-]11/01/09 07:12 AM, ID: 25713930Expert Comment

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]11/02/09 12:48 AM, ID: 25717853Expert Comment

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]11/02/09 01:54 AM, ID: 25718134Author Comment

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 30-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]11/02/09 01:57 AM, ID: 25718146Author Comment

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 30-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]11/02/09 04:19 AM, ID: 25718725Expert Comment

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]11/02/09 11:29 AM, ID: 25722771Author Comment

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 30-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]11/02/09 01:24 PM, ID: 25723910Expert Comment

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20091111-EE-VQP-89 - Hierarchy / EE_QW_3_20080625