How to speed up creating index problems
- From: "Roger Xu" <roger_xu@xxxxxxxxxxx>
- To: <bunjibry@xxxxxxxxx>, "Oracle-L" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 22 Nov 2005 16:58:13 -0600
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]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@xxxxxxxxx
For technical support please email tech_support@xxxxxxxxxxx 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.
____________________________________________________________________
This email has been scanned for all viruses by the MessageLabs Email Security
System. Any questions please call 972-721-8257 or email your request to
tech_support@xxxxxxxxxxxx
Other related posts:
