| Want to use Alias [message #246203] |
Wed, 20 June 2007 05:02  |
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  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
