search-first-letter, Sql Server

Language: Layout:

CREATE TABLE persons
  ( person_id INT IDENTITY PRIMARY KEY,
    lastname VARCHAR(40) NOT NULL,
    firstname VARCHAR(40) NOT NULL
  ) ;
  
CREATE INDEX p_lastname_ix
  ON persons (lastname) ;

CREATE TABLE persons2
  ( person_id INT IDENTITY PRIMARY KEY,
    lastname VARCHAR(40) NOT NULL,
    firstname VARCHAR(40) NOT NULL
  ) ;
  
CREATE INDEX p2_lastname_ix
  ON persons2 (lastname) ;

INSERT INTO persons
  (lastname, firstname)
VALUES 
  ('Andrews',   'Julie'),
  ('Basinger',  'Kim'),
  ('Beethoven', 'Lutvig'),
  ('Carrey',    'Jim'),
  ('Cage',      'Nicolas'), 
  ('Cruz',      'Penelope')
 ;
  
INSERT INTO persons2
  (lastname, firstname)
VALUES 
  ('Adams',     'John'),
  ('Buchanan',  'James'),
  ('Bokassa',   'Jean-Bedel'),
  ('Carter',    'Jimmy'),
  ('Clinton',   'Bill'),
  ('Clinton',   'Hillary') ;
  
CREATE TABLE search
  ( param CHAR(2) NOT NULL PRIMARY KEY
  ) ;

INSERT INTO search
  (param)
SELECT letter + '%'
FROM
  ( VALUES 
      ('A'), ('B'), ('C'), ('D'), ('E'), 
      ('F'), ('G'), ('H'), ('I'), ('J'),
      ('K'), ('L'), ('M'), ('N'), ('O'),
      ('P'), ('Q'), ('R'), ('S'), ('T'),
      ('U'), ('V'), ('W'), ('X'), ('Y'),
      ('Z') 
  ) AS let (letter) ;

SELECT p.*, p2.*
FROM   search s
       INNER JOIN persons p
               ON p.lastname  LIKE s.param
       INNER JOIN persons2 p2
               ON p2.lastname LIKE s.param ;
               
GO

View schema
Execution time: 0,02 sec, rows selected: 14, rows affected: 38, absolute service time: 0,19 sec