Home » RDBMS Server » Performance Tuning » Want to use Alias
Want to use Alias [message #246203] Wed, 20 June 2007 05:02 Go to next message
subho_ORA
Messages: 2
Registered: April 2007
Junior Member
Hi all,
I am using oracle 9i. I want to run this query from my application.
SELECT GNO,TO_CHAR(TO_DATE(RGDATE,'DD/MM/YYYY'),'DD/MM/YYYY'),TRIM(OWNERNAME), TRIM(FNAME)FROM A WHERE NVL(STATE,'N')='N' AND SUBSTR(GNO,-4) BETWEEN 0000 AND 9999 and GNO in(SELECT RNO FROM B where TFLAG IS NULL AND CFLAG IS NULL) ORDER BY GNO

But the problem is that this query taking longer time to fetch the row set.
Is there any way to minimize this time? If Ill use Alias then how to use it? Plzz help me.
Re: Want to use Alias [message #246241 is a reply to message #246203] Wed, 20 June 2007 07:15 Go to previous message
Brayan
Messages: 315
Registered: June 2002
Senior Member
Hi,

Before somebody bounceback format your query. Read sticky.

Quote:
But the problem is that this query taking longer time to fetch the row set

Post explain plan, How may records in tables A,B.

Quote:
If Ill use Alias then how to use it?

Is it table Alias? then it goes like this
FROM <Table> <alias>.

But this is just a reference and nothing to do with tuning!

Brayan
Previous Topic: PLan Cost?-Sql Tuning
Next Topic: Performance of Update Statement
Goto Forum:
  


Current Time: Wed Dec 07 12:43:17 CST 2016

Total time taken to generate the page: 0.22128 seconds