>Thanks Darwin , But try to join a two table having volume of records. that join command will not work rushmore. i tried before :)
>
>parent 20,000 record and child table 30,000 records check the effect.
>
>mond

Mond,

You are incorrect on this. A select on large tables will use Rushmore, if the select is optimizable. SELECTs on table with millions of records can give very fast response times with full optimization.