Hi,

I have a big table (1M rows) with the following columns:

source, dest, distance.

Each row defines a link (from A to B).

I need to find the distances between a pair using anoter node.

An example:

If want to find the distance between A and B,

If I find a node x and have:

x -> A

x -> B

I can add these distances and have the distance beetween A and B.

My question:

How can I find all the nodes (such as x) and get their distances to (A and B)?

My purpose is to select the min value of distance.

P.s: A and B are just one connection (I need to do it for 100K connections).

Thanks !