Technology Network Community
Oracle Database
Fusion Middleware
Development Tools
Server & Storage Systems
Enterprise Management
Berkeley DB Family
Cloud Computing
Big Data
Business Intelligence
Migration and Modernization
E-Business Suite
PeopleSoft Enterprise
JD Edwards World
JD Edwards EnterpriseOne
User Productivity Kit Pro (UPK) and Tutor
Governance, Risk & Compliance (GRC)
Master Data Management (MDM)
Oracle CRM On Demand
On Demand: SaaS and Managed Applications
AutoVue Enterprise Visualization
Agile PLM
Endeca Experience Management
Fusion Applications
Archived Forums



General Questions

table and index in the same tablespace

I have a table and its associated indexes all in one tablespace. Now, will creating a separate tablespace just for the indexes and drop and recreating the indexes the table has in the new tablespace  help ???  Thanks

I meant to ask if this will help in performance ?

In all probability, no.  This may have some housekeeping/ recovery benefits but it is very unlikely to have performance benefits.  Most modern disk arrays are configured so that data access is spread pretty evenly across all the spindles.  If your disk is configured such that you have "hot" and "cold" disks, and if you can move the index to a different tablespace that can be placed on one of the "cold" disks, this will tend to balance out disk I/O and may improve performance.  Justin Distributed Database Consulting, Inc.

Thanks Justin, that makes sense

Related Links

Tradeoffs of 8i vs. 9i client against 9i RAC Database
8i/SCO UnixWare to 10g/Linux Migration
Import problem
numeric or value error: character string buffer too small
EXP problem on Oracle to
how to relocate table in new tablespace in Oracle 8i
Symantec LiveState Recovery Compatibility with Oracle 9i & 10g
Commit by SID
Reg:error while importing
Table size
restricted ROWID
British vs American spelling
10g Enterprise Manager Error
Index leaf entry
Select any dictionary privelege required to connect as system
Help regarding Oracle DBA Interview Questions