iam using 9 database tables in my final itab and i want final-itab data to retrieved from 9 database tables satisfying the conditions of the user given data for 1st table later for 2nd 3rd 4th and upto 9 th database tables data to be retrieved from 1st to 2nd and for 3 rd it should be taken from 2nd..
so i have declared one finalitab and iam putting 9 inner joins .. so as data in my server is less so its getting but how to improve my SELECT query such that i can get faster unless the size of the data onthe server..
so please give me solution for the query...
Thanks in advance..