Skip to Content
0
Former Member
May 30, 2008 at 09:53 AM

to Optimise SELECT- 9 INNER joins

271 Views

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..