Through MB, if you use an object variable to represent the polygon(s) and then do your
multiple query against the variable instead of the table obj
the query will run much faster.
gary
>>> "Adi" <[EMAIL PROTECTED]> 08/06/99 06:04AM >>>
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]
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
