RE: How to improve the performance of this query?

Neuza

-----Original Message-----
From: neuzaalves [mailto:[email protected]] 
Sent: Tuesday, 19 August 2003 5:20 a.m.
To: [email protected]
Subject: [Delphi] How to improve the performance of this query?

Hi,

select A.* ,B.GPE_DESCR,C.SGE_DESCR,D.*  from EITEMBASE A ,EGRUPO 
B,ESUBGRUPO C ,EITEMBASECARAC D where A.GPE_ID=B.GPE_ID and 
C.SGE_ID=A.SGE_ID and D.ITB_ID=A.ITB_ID
order by GPE_DESCR,SGE_DESCR,ITB_DESCR

<snip>

What is the best thing to do?  
-----

The "best thing to do" would be to tell us which database you are using.
My own experience is with Paradox, DBISAM and MSSQL.  In each of these,
the most efficient way to phrase a query can be quite different.  Tell
us which database you are using and someone with specialist knowledge
may be able to help.  OR ... find a newsgroup for your database and ask
the question there.

Cheers

Jeff 

--
Jeff Cook
Aspect Systems Ltd
Phone: +64-9-424 5388
  


------------------------ Yahoo! Groups Sponsor ---------------------~-->
Buy Ink Cartridges or Refill Kits for Your HP, Epson, Canon or Lexmark
Printer at Myinks.com. Free s/h on orders $50 or more to the US & Canada. http://www.c1tracking.com/l.asp?cid=5511
http://us.click.yahoo.com/l.m7sD/LIdGAA/qnsNAA/i7folB/TM
---------------------------------------------------------------------~->

Delphi VCL Top Sites!
http://www.sandbrooksoftware.com/TS/TS2/Components.shtml
---------------------------------------------------------------
Unsubscribe:[email protected]
List owner:[email protected]
--------------------------------------------------------------- 

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/