Home » SQL & PL/SQL » SQL & PL/SQL » Very Large Table to add Index
Very Large Table to add Index [message #187829] Tue, 15 August 2006 20:59 Go to next message
Messages: 13
Registered: August 2006
Location: Taiwan Taipei
Junior Member

Hi everybody~~

I have a very large table about fourteen million records!!

it's no index now~~I want to add indexes on it~~

but the speed is very slow~~anybody has good idea???

thx a lot~~~
Re: Very Large Table to add Index [message #187833 is a reply to message #187829] Tue, 15 August 2006 21:51 Go to previous message
Messages: 3727
Registered: October 2005
Location: Melbourne, Australia
Senior Member
Previous Topic: compare strings
Next Topic: Needed Some suggestion On Performance --Oracle Trigger
Goto Forum:

Current Time: Fri Aug 18 15:06:14 CDT 2017

Total time taken to generate the page: 1.77121 seconds