Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Slow response from a table
Hello,
I think at this point in time you need to reindex. Also if needed you can do further normalization so that access time may reduce.
I hope this helps.
-Uday.
In article <35321e7b.326283555_at_knot.queensu.ca>,
poelsb_at_post.queensu.ca (Ben Poels) wrote:
>
> Hi,
>
> I have an Oracle table that is giving me slow response times. This
> table represents current years data. Access to last year's data table
> is much quicker and I am wondering why? Both tables are in the same
> tablespace. I was the only active session when I did my benchmarks. I
> have exported and imported it and moved it to a different filename on
> a different disk drive with little or no improvement.
>
> Any other suggestions. What statistics should I audit to try to
> discover what is happening here? Thanks,
>
> Ben
> Ben Poels
> Queen's University
> Kingston, ON, Canada
>
-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Mon Apr 13 1998 - 13:52:48 CDT