Home » SQL & PL/SQL » SQL & PL/SQL » Select * taking lot of time (Oracle 10g)
Select * taking lot of time [message #405157] Tue, 26 May 2009 11:43 Go to next message
sridharv
Messages: 3
Registered: May 2009
Junior Member
Hi,

Whenever I use select *, it takes indefinite amount of time. But if I select specific columns, it works fine. Please help.
Re: Select * taking lot of time [message #405160 is a reply to message #405157] Tue, 26 May 2009 11:58 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Only select these specific columns.

Regards
Michel
Re: Select * taking lot of time [message #405162 is a reply to message #405160] Tue, 26 May 2009 12:11 Go to previous messageGo to next message
sridharv
Messages: 3
Registered: May 2009
Junior Member
What if I want all the columns? The same query works fine in my frnd's system but not in mine..
Re: Select * taking lot of time [message #405163 is a reply to message #405162] Tue, 26 May 2009 12:23 Go to previous messageGo to next message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
You didn't provide the query.
You didn't tell what are the differences between your system and your friend's system?
Are you connecting to the same database from both the systems?
(Or) IS each system having its own database?

Anyway check the explain plan in both the systems.

By
Vamsi
Re: Select * taking lot of time [message #405164 is a reply to message #405163] Tue, 26 May 2009 12:29 Go to previous messageGo to next message
sridharv
Messages: 3
Registered: May 2009
Junior Member
We access the same DB. OS is the same and same is the query.
Re: Select * taking lot of time [message #405165 is a reply to message #405162] Tue, 26 May 2009 12:35 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
sridharv wrote on Tue, 26 May 2009 19:11
What if I want all the columns? The same query works fine in my frnd's system but not in mine..

Work with your friend system.

Regards
Michel

Re: Select * taking lot of time [message #405166 is a reply to message #405165] Tue, 26 May 2009 12:57 Go to previous messageGo to next message
joicejohn
Messages: 327
Registered: March 2008
Location: India
Senior Member
Michel Cadot wrote on Tue, 26 May 2009 23:05

Work with your friend system.


./fa/449/0/
Re: Select * taking lot of time [message #405183 is a reply to message #405166] Tue, 26 May 2009 15:18 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
That is not only absolutely hilarious, but it is also the only possible answer given the information we have. ./fa/1581/0/

Of course, everything else depends on what is the actual DIFFERENCE between your friends system and yours?

He could be connected locally with a gigabit LAN while you connect via a modem, for example.

Or he could be running the query in some GUI tool which returns only the first 100 rows, while you run something that tries to return all rows.

We really have no way of knowing.
Re: Select * taking lot of time [message #405372 is a reply to message #405183] Wed, 27 May 2009 08:00 Go to previous message
joy_division
Messages: 4640
Registered: February 2005
Location: East Coast USA
Senior Member
ThomasG wrote on Tue, 26 May 2009 16:18
That is not only absolutely hilarious, but it is also the only possible answer given the information we have. ./fa/1581/0/



I can think of other things to consider too.

Maybe you should try running it from someone's system who is not a friend. How does the fact that the person is a friend make any difference?
Previous Topic: procedure not working properly when run through sys
Next Topic: stored procedure
Goto Forum:
  


Current Time: Sun Dec 04 13:02:48 CST 2016

Total time taken to generate the page: 0.09194 seconds