Code Forums - View Single Post

DJMaze · 12-23-2005, 06:33 AM

You could create an index that uses both tables.
Something like

Code:

CREATE INDEX trip_data ON (trip, data) USING btree (trip.id, data.id);

Code:

SELECT * FROM (trip, data) WHERE trip.id = data.id;

I'm not 100% if this code is correct cos i don't use table binding often.
There's a better one which also supports a great DELETE feature so if you delete a trip.id it also deletes all data entries that have the same id

12-23-2005, 06:33 AM	#4 (permalink)
DJMaze Senior Contributor Join Date: Mar 2005 Posts: 676	You could create an index that uses both tables. Something like Code: CREATE INDEX trip_data ON (trip, data) USING btree (trip.id, data.id); Code: SELECT * FROM (trip, data) WHERE trip.id = data.id; I'm not 100% if this code is correct cos i don't use table binding often. There's a better one which also supports a great DELETE feature so if you delete a trip.id it also deletes all data entries that have the same id