| database optimization [message #51882] |
Wed, 19 June 2002 11:44  |
Tracy
Messages: 43
Registered: January 2000
|
Member |
|
|
Hi -
I was asked to look into why some SQL queries take too long to run. I noticed that the tables being used for the query were created by being placed in tablespace that was supposed to be reserved for INDEXes only. Also, many indexes were created and placed in the tablespace that was to be reserved for TABLEs only. Could this be causing queries that access those tables/indexes to be slower than other queries that access tables/indexes that are in their proper tablespaces?
thank you,
Tracy
|
|
|
|
| Re: database optimization [message #51886 is a reply to message #51882] |
Wed, 19 June 2002 19:44  |
Vikas Gupta
Messages: 115
Registered: February 2002
|
Senior Member |
|
|
Hello Tracy,
You should first run explain plan to check, whether the indexes are being used at all.
Placement of indexes and tables in proper tablespaces also effect the performance, but first make sure that indexes are being used.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
