Re: {NJ} Query problem !

Hi! It shouldn't get so much time to complete. It is strange. Try using the 'set sqexplain on' and run the query again and check the query path. Best Regards, Octav On Mon, Apr 26, 1999 at 03:17:42PM +0530, Nayan Jain wrote: > Hi ! > > Thanks a lot for ur help...It worked ! > It really worked ! But earlier the problem was tht if u have too much data > it crawls and i was thinking tht there is a problem in the query itself. > > May be it is this tht our database is very slow. > > Thanks a million for help...it saved me (-; > > Nayan ! > > > > > > > > Let's see what we can do. > > > > First of all - I've tested it on a table with 3139 rows. It works fast. > > > > But - I have an index on 'first' field. And after creating index I would > > > > run an update statistics on this table. > > > > > > > > As of the second question - sorry I didn't understand you very well. > > > > So, you want to get the rows ordered by the count of first field. > > > > It is much simple: > > > > > > > > select (select count(*) > > > > from tab1 b > > > > where b.field1 = a.field1), > > > > a.* > > > > from tab1 a > > > > order by 1 > > > > > > > > Best Regards, > > > > Octav > > > > > > > > > > > > NAYAN JAIN wrote: > > > > > > > > > > Hi again ! > > > > > > > > > > Sorry but i m sending this mail to u only. > > > > > > > > > > Thanks for ur answer...but your query seems to be a bit complex. > > > > > > > > > > For my table with 3359 records it is running for last 25 minutes. > > > > > ?????? > > > > > > > > > > Wht to do ? > > > > > > > > > > Should i send u my table / data so tht u can guide me well ? > > > > > > > > > > Also if i m not clear... > > > > > > > > > > I want to display all the 3359 records from the table but all the > > > > > records where field 1 count(*) is maximum are to be displayed first. > > > > > > > > > > Like in my example... > > > > > A first (all records having field 1 as A) > > > > > B second > > > > > C third > > > > > > > > > > ???? > > > > > > > > > > Please reply asap > > > > > > > > > > TIA, > > > > > Nayan ! > -- Octav Chiriac Phone: (373) 2 21 20 96 NetInfo S.R.L. Fax: (373) 2 21 36 59 Chisinau (373) 2 24 00 83 Moldova, Republic of mailto:com@netinfo-moldova.com