hi to all
after long time.facing one problem.i have to tables
in first table i have total number of records(14791014) &
Second table i have total number of records(464419)
in my form i have 2 grids.when i try to search from this
two tables & display this information to grid it is taking around 6 minutes to diaplay data.i am using SQL statment.
anyone can help me on this issue to reduce time


Best regards
Mazahir