Home » RDBMS Server » Performance Tuning » fast query
fast query [message #601801] Mon, 25 November 2013 23:36 Go to next message
narang79
Messages: 131
Registered: June 2010
Senior Member
i m using oracle 9.2.0.8 and devloper 2000
i have a table which have multiple column and rows
peformance of this table is very slow
i cant use primary key on this table
there is no constraint and index on this table
plan is attached
how i can fast this
Re: fast query [message #601807 is a reply to message #601801] Mon, 25 November 2013 23:43 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/m/433888/#msg_433888
Please refer to URL above & be sure to provide the details requested:
1) DDL for all tables & indexes
2) EXPLAIN PLAN
3) output from SQL_TRACE & tkprof
Re: fast query [message #601808 is a reply to message #601801] Mon, 25 November 2013 23:43 Go to previous messageGo to next message
narang79
Messages: 131
Registered: June 2010
Senior Member
plan is
  • Attachment: plan.JPG
    (Size: 89.33KB, Downloaded 1257 times)
Re: fast query [message #601809 is a reply to message #601808] Mon, 25 November 2013 23:48 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/
Re: fast query [message #601821 is a reply to message #601809] Tue, 26 November 2013 02:16 Go to previous messageGo to next message
Roachcoach
Messages: 1576
Registered: May 2010
Location: UK
Senior Member
The problem appears to be line 2.
Re: fast query [message #601829 is a reply to message #601821] Tue, 26 November 2013 04:07 Go to previous messageGo to next message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
Are you really running a query to pull all the data from the table?
How long does it take?
Re: fast query [message #601851 is a reply to message #601829] Tue, 26 November 2013 08:00 Go to previous message
Kevin Meade
Messages: 2103
Registered: December 1999
Location: Connecticut USA
Senior Member
Assuming everything is as you have told us (your problem description is rather lacking in details), and that your requirement is indeed to fetch all rows from this table, then there is little you can do to make it go faster.

There are other features of the database you can exploit. But since you seem to be rather new to Oracle and do not know much about it I hesitate to introduce you to any of them as they are advanced topics and you are not ready for them yet.

I think there is a lot more to the story than you have told us and because of this there is not much we can really help you with. For example, the following terms suggest possible areas of investigation (compression, covering index, partitioning, TOP-N pagination query,table caching and keep pools, etc.), but there are no details of what your system is like, the scenario underwhich you excute this query, how volitile this table is, how it is populated and used in general, and so on; so there is no way to recommend any of this or something else.

We need a fuller discolsure of what the app does, what data you really want if not all rows, if all rows are needed then why and what does the app do with them, and the other things I mention above.

Good luck, Kevin

[Updated on: Tue, 26 November 2013 08:03]

Report message to a moderator

Previous Topic: Please help me my query performance is bad.
Next Topic: Performance degrade
Goto Forum:
  


Current Time: Thu Mar 28 12:14:39 CDT 2024