Re: ideas to use ora hash
- From: "Glenn Santa Cruz" <glenn.santacruz@xxxxxxxxx>
- To: juancarlosreyesp@xxxxxxxxx
- Date: Tue, 21 Mar 2006 07:52:50 -0600
Not sure how you'd apply this to tuning, or to reduce storage space,
but we used it to provide a pseudo-random ordering of rows for a
particular application. The requirement was to provide a random list
of entries from a table, but the list needed to be "page-able" (think
of web site, displaying page 1 of 10, etc). We couldn't just order by
dbms_random.random, since that would effectively break pagination; and
we had to keep these in order for the particular web session.
Solution? Concatenate the unique web session identifier with another
unique column in the table and sort by the hashed value. Worked quite
well.
Glenn
On 3/21/06, Juan Carlos Reyes Pacheco <juancarlosreyesp@xxxxxxxxx> wrote:
> Hi list
> Does anyone has an interesting idea about how to use, specially for tuning,
> ora_hash or DBMS_UTILITY.GET_HASH_VALUE, to get hash values.
>
> One is to encrypt, but I was asking about the possibility to use to
> reduce storage space or to tune, does anyone can share some idea
> and/or experience.
>
> Thank you :)
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
