OraFAQ Forum: SQL & PL/SQL » Tunning of SQL,it fetches more than one lakh rows

Home » SQL & PL/SQL » SQL & PL/SQL » Tunning of SQL,it fetches more than one lakh rows (Oracle 9i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Tunning of SQL,it fetches more than one lakh rows [message #320499]

Thu, 15 May 2008 05:18

na.dharma@gmail.com
Messages: 82
Registered: May 2008
Location: bangalore

Member

Hi All

I have select statment which fetches more than one lakh rows.
Its taking too much time, can anybody tell me how can i tune my query?
Note:- I dont want to use where clause in the select statement, coz i want all the column values..

Query is as below
select * from xyz

Thanks,

Report message to a moderator

Re: Tunning of SQL,it fetches more than one lakh rows [message #320500 is a reply to message #320499]

Thu, 15 May 2008 05:24

JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...

Senior Member

You might be able to parallelize it.

If XYZ is a view, you might be able to tune the underlying query.

Other than that, nope. Nothing you can do.

Report message to a moderator

Re: Tunning of SQL,it fetches more than one lakh rows [message #320503 is a reply to message #320499]

Thu, 15 May 2008 05:29

S.Rajaram
Messages: 1027
Registered: October 2006
Location: United Kingdom

Senior Member

Is this table frequently updated/deleted? If that is the case then you might considering re-org the table. For what I mean by Reorg, search on google.

Also, from next time, please please rather than saying it is taking too much time try to quantify your statement. Tell us it is taking 2 hours, 1 hour. Also, read the very first link on performance tuning section in this forum.

Regards

Raj

[Updated on: Thu, 15 May 2008 05:31]

Report message to a moderator

Re: Tunning of SQL,it fetches more than one lakh rows [message #320505 is a reply to message #320499]

Thu, 15 May 2008 05:38

msmallya
Messages: 66
Registered: March 2008
Location: AHMEDABAD, GUJARAT

Member

Quote:

taking too much time

means what? Response time?
After issung "select * from xyz" immediately you should get the output, but to display 1 Lac rows, it will take some time.

Regards,

MSMallya

Report message to a moderator

Previous Topic:	PL/SQL: ORA-04052: error
Next Topic:	Can we rename a constraint

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Feb 11 09:05:51 CST 2025