Re: creating tablespaces for performance

ashrivastava_at_auriga-insys.com (Anand) 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

Almost always :no, and definitely not if the 2 tablespaces are on 1 disk.
You need to provide more clues as to what is going on, because otherwise no one will be able to help you. Crystall balls sold out a long time ago.
Given the small number of records there shouldn't be any problem.

Regards

Sybrand Bakker
Senior Oracle DBA Received on Wed Sep 11 2002 - 14:12:09 CEST