topic Re: Database Index Problem in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/database-index-problem/m-p/1527294#M241324 <HTML><HEAD></HEAD><BODY><P>Check, you have selected the radio button </P><P>Non-unique Index --&gt;Index on all database systems</P><P></P><P>Regards,</P><P>Prakash.</P></BODY></HTML> Thu, 24 Aug 2006 09:29:45 GMT Former Member 2006-08-24T09:29:45Z Database Index Problem https://community.sap.com/t5/application-development-and-automation-discussions/database-index-problem/m-p/1527293#M241323 <HTML><HEAD></HEAD><BODY><P>Hi </P><P></P><P>I have create an index with 4 columns. Wow, my select is very fast. But only one day. Next day the index dosn't match. Explain plan sad full table scan - so the statement is very slow. If I anlayze the table - nothing changes, but if I go to the database utility and select the index and klick the button "activate and adjust database" the statment works very fast - but only for one day. Any idea whats wrong.</P><P></P><P>Thanks Stefan</P></BODY></HTML> Thu, 24 Aug 2006 09:18:37 GMT https://community.sap.com/t5/application-development-and-automation-discussions/database-index-problem/m-p/1527293#M241323 Former Member 2006-08-24T09:18:37Z Re: Database Index Problem https://community.sap.com/t5/application-development-and-automation-discussions/database-index-problem/m-p/1527294#M241324 <HTML><HEAD></HEAD><BODY><P>Check, you have selected the radio button </P><P>Non-unique Index --&gt;Index on all database systems</P><P></P><P>Regards,</P><P>Prakash.</P></BODY></HTML> Thu, 24 Aug 2006 09:29:45 GMT https://community.sap.com/t5/application-development-and-automation-discussions/database-index-problem/m-p/1527294#M241324 Former Member 2006-08-24T09:29:45Z