| fast query [message #601801] |
Mon, 25 November 2013 23:36  |
narang79
Messages: 137
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 #601851 is a reply to message #601829] |
Tue, 26 November 2013 08:00  |
 |
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 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
