Home » SQL & PL/SQL » SQL & PL/SQL » Tunning of SQL,it fetches more than one lakh rows (Oracle 9i)
Tunning of SQL,it fetches more than one lakh rows [message #320499] Thu, 15 May 2008 05:18 Go to next message
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,
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 Go to previous messageGo to next message
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.
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 Go to previous messageGo to next message
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 Go to previous message
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
Previous Topic: PL/SQL: ORA-04052: error
Next Topic: Can we rename a constraint
Goto Forum:
  


Current Time: Sat Dec 03 14:05:00 CST 2016

Total time taken to generate the page: 0.08622 seconds