Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
You donot need to specify the index in your select statement. Just include the fields on which the index is created in the where clause of the select statement, The optimizer will choose the appropriate index at run-time so as to optimize the performance.
I have to give the Index in the select query only when i am retrieving the data from database table, how to write the query , can any body send me th code.
You donot need to specify the index in your select statement. Just include the fields on which the index is created in the where clause of the select statement, The optimizer will choose the appropriate index at run-time so as to optimize the performance.
when we creating the table, primary index will creeated automatically. Other than this we can created the secondary indexes. so we writing the select query, the sap itself will select the correct index with respect to the fields u specified in the select query
Just specify the fields on which those indexes are created in the where clause of the select statement. The optimizer will choose the best index at run-time. You will not be able to specify an index EXPLICITLY with the select statement.
Bluesky
