Re: creating tablespaces for performance

Maybe and maybe not. If the other tablespace is on a different spindle then maybe if it is not then no. eg if you have everything on one drive then creating another tablespace isn't going to increase the response time of that drive. How could it? Performance is usually related to physics. You need to understand the physics of what is going on. There isn't any _turbo_mode=true setting. You need to look at the explain plan and see what the query is doing. You should be using bind variables (probably aren't). Your DBA should be able to help you out. I find it difficult to believe that you can't find out any basic information about the machine. (eg how many hard drives it has, how the data is distributed on them, is it mirrored, raid 5, striped and mirrored)

I bet that if you looked at the explain plan for the offending query it would tell us something. (Like the distinct is causing a sort to disk and slowingthings down, remove distinct and see if it is faster, if so then consider increasing sort area size).

Jim

"Anand" <ashrivastava_at_auriga-insys.com> wrote in message news:396cc940.0209102156.919a9d_at_posting.google.com...
> I don't have information about the setup because the database is
> hosted onto a different web server.
> The performance issue comes whenever I try to access those two tables.
> Even a simple select query takes quite a lot of time; and for my
> application's purpose I need to take join of both the tables. As far
> as other tables are concerned, I am able to run almost any type of
> queries without much of the delay.
> To be more precise, I had created an ASP application which was workin
> fine till the data tables had only 10k records, but as the size of
> these tables grew the application started timing out. Later I found
> that simple queries like "select distinct name from table1" times out
> when queried through application but gives me results when queried
> through Oracle client with slight delay. That indicates that I may
> have to do certain exercise on the ODBC layer also... still I would
> always like to fine tune my database end as much as possible.
> Now returning to my original question, "Does keeping larger tables in
> seperate tablespace improve performance?"
> Regards,
> Anand
Received on Wed Sep 11 2002 - 14:44:29 CEST