RID pool analysis

[login to unmask email]

RID pool analysis
Hi all

Can some one clearly define 'QW0125TH'

Thanks Tom



Venkat (PCA) Pillay

Re: RID pool analysis
(in response to ttaylor@CHUBB.COM)
This is threshold value stored at the time of bind for static sqls. Assume
20000 rows table and list-prefetch has already got done 5000 qualifying
RIDs. This 5000 is threshold when RID access would fail. (min of 4k rids).
This is 25% limit for rid failure

> -----Original Message-----
> From: [login to unmask email] [SMTP:[login to unmask email]
> Sent: Thursday, December 16, 1999 2:43 PM
> To: [login to unmask email]
> Subject: RID pool analysis
>
> Hi all
>
> Can some one clearly define 'QW0125TH'
>
> Thanks Tom
>
>
>
>
>