Problem solved! As you were suggesting it was the inner joins that were restricting it (they were trying to join on Foreign Keys that don't exist yet). I've changed the...

Hi All,

This is all of it:

Alter  View vw_VoyageContainers

WITH SCHEMABINDING

AS

 Select

  vc.VoyageContainerID,

  v.VoyageID,

  c.ContainerID,

  --v.ParentID,

  v.VoyageRef,

  vs.VesselName,

  c.ContainerNo,

  p.etd,

  pol.PortName AS POL,

  d.eta,

  vt.VoyageType,

  v.VesselID,

  v.VoyageStatusID,

  v.VoyageTypeID,

  --v.CreatedDate,

  v.FirstETA, 

  v.FirstETD,

  p.Polid,

  d.PODID

 From

  dbo.VoyageContainers vc

 Inner JOIN

  dbo.Voyages v ON

  vc.VoyageID =  v.VoyageID

 Inner JOIN

  dbo.Vessels vs ON

  vs.VesselID =  v.VesselID

 Inner JOIN

  dbo.VoyagePol p ON

  p.VoyageID...

SET QUOTED_IDENTIFIER ON

Create Unique Clustered Index vw_index ON vw_VoyageContainers(ID, colA, colB, colC)

I know that the above index doesn't match the tables exactly, but this is bascially what it looks like,...