Dear List members.
I have one polygon table and few point table. And many a
times I need to run the query to identify the particular point
falls in which polygon or in a particular polygon how many
points are there. for this I run this simple query (through MB)
Run_depot = "select dname from "+szboun_name+", "+
TAB_TO_SEARCH +" where "+ TAB_TO_SEARCH+".NAME
= "+""""+city_find+""""+" AND "+szboun_name+".obj
contains "+TAB_TO_SEARCH+".obj into depot_found"
Actually Syntex I use is :
select col from poly_tab, point_tab where point_tab.desiredcol
= "Value" and poly_tab.obj contains point_tab.obj
( If I use this in two line syntex as first selecting the name of point
and then the output point is searched in polygon table it is
much faster , but the only problem is MI can perform dynamic
join only on base tables, so I will have to save the intermediate table
and that is too tedious process and occupies unnecessaty space in Harddisk)
this takes at least 1 min. to give result.
How can I optimize it for min. time.
Thanks a lot
===================================================
Aditya
Executive (Systems)
Information Systems Department
GCMMF, Anand
E-mail me at Mailto:[EMAIL PROTECTED]
Web Site: http://www.amul.com
===================================================
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
