Home » RDBMS Server » Performance Tuning » to make fast retrival (oracle 10g, xp)
to make fast retrival [message #327512] Mon, 16 June 2008 12:18 Go to next message
sd_md_rizwan@yahoo.com
Messages: 37
Registered: September 2007
Location: Saudi Arabia
Member

hi all,
i have a table holding 11 million records and i created a bitmap
index on that table and when i select the data from that table
it is taking more than 5 to 6 minutes i think is very long time
all made all required tuning to make my retrival fast but no use
can some body tell me the things what to do, may be iam missing something which may be the cause.
please help soon.
Re: to make fast retrival [message #327513 is a reply to message #327512] Mon, 16 June 2008 12:20 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & follow posting guidelines as stated in URL above

http://www.orafaq.com/forum/t/84315/74940/
which of the suggestions in URL above have you tried & what were the results?

Are statistics current?
Re: to make fast retrival [message #327514 is a reply to message #327512] Mon, 16 June 2008 12:21 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
You can first read:
- OraFAQ Forum Guide, Performance Tuning section
- How to Identify Performance Problem and Bottleneck
- OraFAQ Performance Tuning
- Rosco's SQL Tuning Guide

Then provide the requested and usual information.

You can also have a look at Database Performance Tuning Guide.

Regards
Michel
Re: to make fast retrival [message #330284 is a reply to message #327512] Sat, 28 June 2008 15:21 Go to previous message
Kriptas
Messages: 118
Registered: June 2008
Senior Member
what size of table?
show us execution plan
what cardinality of indexed column
write more detail information please.
Previous Topic: Segment Tuning --- TablePartition
Next Topic: Query is taking more time to execute
Goto Forum:
  


Current Time: Fri Dec 06 23:42:32 CST 2024