OraFAQ Forum: Performance Tuning » to make fast retrival

Home » RDBMS Server » Performance Tuning » to make fast retrival (oracle 10g, xp)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

to make fast retrival [message #327512]

Mon, 16 June 2008 12:18

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.

Report message to a moderator

Re: to make fast retrival [message #327513 is a reply to message #327512]

Mon, 16 June 2008 12:20

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?

Report message to a moderator

Re: to make fast retrival [message #327514 is a reply to message #327512]

Mon, 16 June 2008 12:21

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

Report message to a moderator

Re: to make fast retrival [message #330284 is a reply to message #327512]

Sat, 28 June 2008 15:21

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.

Report message to a moderator

Previous Topic:	Segment Tuning --- TablePartition
Next Topic:	Query is taking more time to execute

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 30 01:02:19 CST 2024