OraFAQ Forum: SQL & PL/SQL » querying based on a function

Home » SQL & PL/SQL » SQL & PL/SQL » querying based on a function

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

querying based on a function [message #22943]

Thu, 07 November 2002 02:09

Sean Dwyer
Messages: 4
Registered: November 2002

Junior Member

Hi,
I have a table where each record can be 1 of 2 states 'D' or 'E', however the state can only be determined by passing the primary key into a function.
How can I quickly retrieve all the 'D' records?
Thanks,
Sean

Report message to a moderator

Re: querying based on a function [message #22945 is a reply to message #22943]

Thu, 07 November 2002 03:28

Shiju
Messages: 12
Registered: October 2002

Junior Member

create a BITMAP INDEX on that column

Report message to a moderator

Re: querying based on a function [message #22961 is a reply to message #22943]

Thu, 07 November 2002 09:56

Todd Barry
Messages: 4819
Registered: August 2001

Senior Member

And why can't you just query the table directly? If this is a security issue, accessing the value through a function is highly inefficient.

Report message to a moderator

Previous Topic:	How we use these in sql
Next Topic:	Update one column - multiple rows

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Apr 29 08:58:43 CDT 2024