| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> How to speed up creating index problems
40+ minutes to create an index on a 1 TB table - that is fast for us.
It took me the same time to create an index on a 15 GB table.
How come? "alter session set sort_area_size"? Parallel?
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Bryan Wells
Sent: Tuesday, November 22, 2005 12:49 PM
To: Oracle-L
Subject: Creating index problems
Hi... we are having issues trying to create indexes from a remote location. we have access to the console and are running the create index on the server, but it takes 40+ minutes to create. BTW... this table is 1Tb. however, when performing the same operation at another location, same configuration as before, the index only takes 10min. what am i missing? both of these servers are SAN attached. the indexes are being created on the SAN.
--
Bryan S Wells (Perpetually Stumped)
Database Administrator
bunjibry_at_gmail.com
For technical support please email tech_support_at_dp7uptx.com or you can
call (972)721-8257.
This email has been scanned for all viruses by the MessageLabs Email Security System.
This e-mail is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Any review, dissemination, copying, printing or other use of this e-mail by persons or entities other than the addressee is prohibited. If you have received this e-mail in error, please contact the sender immediately and delete the material.
 |
 |