OraFAQ Forum: SQL & PL/SQL » query performance

Home » SQL & PL/SQL » SQL & PL/SQL » query performance (11g )

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

query performance [message #670587]

Sat, 14 July 2018 05:34

annu-agi
Messages: 238
Registered: July 2005
Location: Karachi

Senior Member

Dear experts

in my query i have a requirement to get result which is greater then 0 , for e.g.

where primary_quantity>0

when i include this condition then it reply dead slow other wise it working fine. well table is huge in size and having millions of data and you know we cannot create index on it.

will you please tell me how can i handle this

regards

anwer

Report message to a moderator

[Message index]

		query performance By: annu-agi on Sat, 14 July 2018 05:34
		Re: query performance By: Michel Cadot on Sat, 14 July 2018 05:48
		Re: query performance By: EdStevens on Sat, 14 July 2018 14:50
		Re: query performance By: Bill B on Tue, 17 July 2018 06:29

Previous Topic:	how to work around the substitution variables in plsql
Next Topic:	Need Help on Pl/Sql

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 06:18:55 CDT 2024