Paul,
I don't know of any document for UDB on UNIX, like there is for OS/390. I
usually use dynexpln to get the plan. When looking at the plan I review the
section where it has "Sargable Index Predicate(s)". I am interpreting this to
mean the predicates are similar to Stage 1 on MVS.
Roy
Paul Turpin wrote:
> I cross-posted this message to DB2-L.
>
> In the UDB (on UNIX) world has anyone seen a list of indexable
> predicates,
> similar to the list you see for OS/390 DB2.
>
> Does anyone know if there is something like Stage 1 and Stage 2 (OS/390
> DB2) processing in UDB? I have read the chapter in the UDB Admin.
> Guide: Performance, entitled "Understanding the SQL Compiler", but I was
>
> unable to find the indexable predicate information I am seeking.
>
> =====
> To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
> For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
