Deepak,
I would like to mention just a couple of things here.
1. select NVL(substr(A,0,2), 'null' ) from (select distinct A
from
tabA ) order by A
1. Are you sure this is what you want? I mean, if you have 'AAB',
'AAC' and 'AAD' in the table, do you want three 'AA's in the result set?
If No {
Select Distinct NVL(substr(A,0,2), 'null' ) from tabA
would be faster in addition to being more accurate.
}
else {
Having an Index on column A could make order-of-magnitude
difference in 'Select Distinct'
}
Aby
-----Original Message-----
From: Deepak Kumar Adhikary [SMTP:[EMAIL PROTECTED]]
Sent: Friday, April 30, 1999 4:25 PM
To: Curt Springer;
[EMAIL PROTECTED]; Grace Frederick
Subject: Re: [ND] ND4 - Taking too much time to load page
with associated data obje cts
Importance: High
Thanks Grace for the detail analysis.
The queries which we have are as follows : I have got rid of one
data
object as 2 combo boxes are being populated with the same data
exactly.
1. select NVL(substr(A,0,2), 'null' ) from (select distinct A
from
tabA ) order by A
2. Same query as above
3. select NVL(B,'null' ) from ( select distinct B from tabB )
group by B order by B
4. select NVL ( C, 'null' ) from ( select distinct C from tabA)
order by C
5. select NVL( substr(A,7,length(A)), ' ' ) from (select
distinct A
from tabA ) order by A
_________________________________________________________________________
For help in using, subscribing, and unsubscribing to the discussion
forums, please go to: http://www.netdynamics.com/support/visitdevfor.html
For dire need help, email: [EMAIL PROTECTED]
