Skip to Content

Indexes for z table

Hi

i created an index to a z table i've created. i am loading 2000000 records to this table and want the select to use the new index i created.

When i select from the Z table according to the index keys he doesnt use this index but use index 0 ( the deafult index ).

What can i do in order to make the select use my index , when i use the HINT command i get the message that the index isnt active which is incorect.

but after i do DB20 the select use this index?

Is DB20 is a must ? how can i make the select use my index other than by HINT ?

Thanks Ami

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jan 06, 2014 at 09:07 AM

    Hi Ami

    is your index active from SE11 .. and you need to check the table in DB20 transaction to ensure that statistics for this table is updated.

    Only when the statistics is updated , it will be taken into account by the CBO.

    Thanks

    Rishi

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 06, 2014 at 08:53 AM

    Please check status of index in SE11. It should be activate and saved as shown below


    index.png (3.0 kB)
    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.