Home » RDBMS Server » Performance Tuning » After Defining Index (10.2.0.1)
After Defining Index [message #352889] Fri, 10 October 2008 01:35 Go to next message
pmapc
Messages: 46
Registered: July 2008
Member
hi,

After defining index on one of my tables it takes some hours to see the result of indexes on queries. for example right after index definition a query which return 50000 records takes 10 seconds to show the result, but after passing some hour same query takes 0.04 seconds for showing result.I was wondering what is behind the scene, for performing what kind of tasks oracle need time, if I know what are they, may be I could speed up the process or at least find the sensible reason for my customer to wait for this actions?

any idea about what going on after index definition?
thanks,
Re: After Defining Index [message #352892 is a reply to message #352889] Fri, 10 October 2008 01:56 Go to previous messageGo to next message
rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia
Senior Member
Are you gathering statistics?

Ross Leishman
Re: After Defining Index [message #352893 is a reply to message #352892] Fri, 10 October 2008 02:02 Go to previous message
pmapc
Messages: 46
Registered: July 2008
Member
no, how it could help me?
would you please guide me a little more.
Previous Topic: General Question
Next Topic: query slow after 10g upgrade
Goto Forum:
  


Current Time: Mon Dec 09 20:38:17 CST 2024