Re: Why is SQL not using an index I created.

["Mark Adkins" <adkinsm@xxxxxxxxxx>]

Well, it all started because SQL wouldn't use the index for a join.

I have two files with the exact same composite index.  The join always
wants to create an index before joining the files.  Any other ideas?

Thanks for the info on indices, you can query Logical Files directly but
not Indices.

Mark Adkins



                                                                                
                                       
                    Brian Ellis                                                 
                                       
                    <bellis@wd-wpp.co        To:     RPG400-L@midrange.com      
                                       
                    m>                       cc:                                
                                       
                    Sent by:                 Subject:     Re: Why is SQL not 
using an index I created.                 
                    owner-rpg400-l@mi                                           
                                       
                    drange.com                                                  
                                       
                                                                                
                                       
                                                                                
                                       
                    08/09/01 11:05 AM                                           
                                       
                    Please respond to                                           
                                       
                    RPG400-L                                                    
                                       
                                                                                
                                       
                                                                                
                                       




You cannont specify indexes directly you need to specify the physical
table.  Let the SQL engine decide which is the best index to use.


Mark Adkins wrote:
>
> When I try to access the index directly it says it doesn't exist.  I've
> tried starting a clean Interactive SQL session, signing off and back on,
> etc.  I can find the table and index in QADBIFLD.
>
> How do I get the index visible by SQL?
>
> Appreciate any help,
>
> Mark Adkins
>
> +---
> | This is the RPG/400 Mailing List!
> | To submit a new message, send your mail to RPG400-L@midrange.com.
> | To subscribe to this list send email to RPG400-L-SUB@midrange.com.
> | To unsubscribe from this list send email to
RPG400-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator:
david@midrange.com
> +---

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



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