Home » SQL & PL/SQL » SQL & PL/SQL » Oracle table Maintainance
Oracle table Maintainance [message #237316] Mon, 14 May 2007 02:52 Go to next message
Messages: 144
Registered: February 2007
Location: india
Karma: 0
Senior Member


My version is 9i.

In a table had one lakh records are there.it contains lot of null values and duplicate values , retrieve records time is very slow . what are steps are doing now that table is efficent and any more process are there?

Any body help to me..


Re: Oracle table Maintainance [message #237328 is a reply to message #237316] Mon, 14 May 2007 03:04 Go to previous message
Messages: 283
Registered: December 2006
Location: Netherlands
Karma: 0
Senior Member
Maybe you can post explain plan / create-statements / sql which is slow.

Otherwise we are shooting in the dark.
Previous Topic: Design Question
Next Topic: cursor is open or not?
Goto Forum:

Current Time: Tue Aug 22 13:51:25 CDT 2017

Total time taken to generate the page: 0.01846 seconds