Re: Query Optimizer

[John P Carr <jpcarr@xxxxxxxxxxxx>]

Bruce said;
>Just going by what I have been told by the database guys at IBM.
>
>Now, can you explain this "one member" theory to me? I mean, you CAN have
>multiple members. You need overrides for SQL to get to them but nothing is
>stopping you. Just because SQL won't create the multiple members, there is
>nothing stopping you from changing it.


Bruce, 
No,  The question was "Whats the difference between Indexes(LF's & PF's)
created via  SQL and those created via DDS.   

You said,    
"" >>As for the difference between an index created by SQL and DDS, that
>depends.  Ultimately, the only real indication of where the logical was
created is a
>>singular flag in the object.  It is not used for anything, it just
>indicates the source of the logical.  ""


I said "One of the things that the "Created via SQL" object flag controls  
along with other things is that it has a MAXMBR's of one.  
And that aspect can't be changed. 

Try creating a Table or View using SQL and then try changing MAXMBR's to 
any thing other than 1.     Also REUSEDLT is *YES 
and other things.  

John Carr


+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---