CREATE TABLE IF NOT EXISTS `myHeadline` (
  `myGroup` int(11) NOT NULL AUTO_INCREMENT,
  `Headline` varchar(20) NOT NULL,
  PRIMARY KEY (`myGroup`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;


INSERT INTO `myHeadline` (`myGroup`, `Headline`) VALUES
(1, 'Headline 1'),
(2, 'Headline 2'),
(3, 'Headline 3'),
(4, 'Headline 4'),
(5, 'Headline 5'),
(6, 'Headline 6'),
(7, 'Headline 7'),
(8, 'Headline 8'),
(9, 'Headline 9'),
(10, 'Headline 10');

CREATE TABLE IF NOT EXISTS `myTable` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `myGroup` int(11) DEFAULT NULL,
  `myContent` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`ID`),
  KEY `Group` (`myGroup`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=101 ;


INSERT INTO `myTable` (`ID`, `myGroup`, `myContent`) VALUES
(1, 3, '=S`l-G'),
(2, 3, 'e+Mz"s;<Jo%5FXy}6'),
(3, 2, '2UDtQQ'),
(4, 1, ':aOFtA'),
(5, 1, 'PVq@:8.'),
(6, 3, '#L|Ap&3y9q44:VT`'),
(7, 4, '''jP%X''k]NnA'),
(8, 1, 'q'),
(9, 1, 'DWANGTF&'),
(10, 1, 'PO&0ABH_gW1K`S a'),
(11, 2, 'S[4,Aq^G'),
(12, 4, '`x1xnQ5m;{S?kt>'),
(13, 4, 'U~d'),
(14, 1, ':FQNA#o^Elg*R1T\\'),
(15, 4, '8_l0W$7w,S'),
(16, 2, '.=7?Ub5Y1#0/5&<IfC'),
(17, 3, '<#}9'),
(18, 2, '<XG'),
(19, 1, 'N`A{HD5+_2G7ka~F])'),
(20, 4, 'Ovv*;2<r;nH'),
(21, 1, ',"UZHhO V]o"]'),
(22, 4, 'y&C3%"FYVu['),
(23, 2, ')iXwUsbbZ>1"3Z1'),
(24, 3, 'JJVl:oD%r0*'),
(25, 1, 'U2y|'),
(26, 2, 'c~_E@-<g44^Tt4Cv'),
(27, 1, ''),
(28, 2, 'ozqOu>s,~_]"!|<9H'),
(29, 4, 'uuA^L}'),
(30, 2, 'QXjpkbT$ <"'),
(31, 1, 's78KZv n-w'),
(32, 1, 'hzd222/%K+WACoJ'),
(33, 3, 'S#b-sx(CJlH6bQ'),
(34, 2, '{E#k7}@^0~'),
(35, 3, '6'),
(36, 1, 'c&SF;Q5$oc8?'),
(37, 4, ':8)?B^"0'),
(38, 4, 'qX1MOI'),
(39, 2, '$mUelpR['),
(40, 2, 'Rbg\\&cY'),
(41, 1, '*''=$+FT'),
(42, 4, 'eGohc!,4(A$5ZVAVv'),
(43, 1, 'YC''1r)h4zCd=NAE^,rv'),
(44, 2, 'R7mFS#"sv7KNwI'),
(45, 3, '2DK2Q<B|Dr+YthF'),
(46, 3, 'RbrHzLJg'),
(47, 1, 'Q|-!'),
(48, 1, 'llB= Kp'),
(49, 2, 'wwCqTK)}EJ?"'),
(50, 1, ''),
(51, 4, 'JQM5#<eI,'),
(52, 1, '$XP$Y#M(N-Gg+G,!P#'),
(53, 1, '8LwT'),
(54, 3, 'W-I(<51B:}2l;!zVwU'),
(55, 1, '#|'),
(56, 1, 'B-V%oThy<Sd5kj_w?'),
(57, 4, 't"BVBm_E^HD2g%Gv;'),
(58, 4, ''),
(59, 2, '5k~qbu'),
(60, 2, ''),
(61, 4, 'T9|Pc'),
(62, 1, '0H''a*JR'),
(63, 2, 'yTh^]G'),
(64, 3, 'c/7S:|S^78(&a@'),
(65, 1, 'v1'),
(66, 2, '3Sq\\_W.Kdbu''(,'),
(67, 4, 'O`R<@O{'),
(68, 4, 'w<O4\\1V8d2K=IoUca2'),
(69, 3, 'Yn'),
(70, 4, 'ZMqI{'),
(71, 4, 'fZ,7LyvXzWKIBN('),
(72, 2, '{l}W5!!Do$IHyN+'),
(73, 3, 'N<SFRN'),
(74, 1, 'N^YL'),
(75, 4, '$4Nm}'),
(76, 2, '_5'),
(77, 4, 'XK''R<szUM)1._->'),
(78, 1, '&Ee5e1DcX`(='),
(79, 3, '#>z='),
(80, 1, '#ZyZU6 5r*_D$^v) c'),
(81, 1, 'My|'),
(82, 1, 'G'),
(83, 1, 'X'),
(84, 4, 'fPEYK*CO{cHz>*y7'''),
(85, 1, '>eL9}%@rNm>RF'),
(86, 4, 'Nveb5-DT_9@(98Q'),
(87, 1, 'Yl'),
(88, 1, 'KauU{rA'''),
(89, 3, ';2[)$8Yc'),
(90, 4, 'wj''~''!Q(Vjl$t@^~'),
(91, 3, '/'),
(92, 4, 'xVpu1\\fboM'),
(93, 2, 'K'),
(94, 2, 'N>Ec>"\\Wv!(:@`OB'),
(95, 1, '+t9UclCEzdpYiduH#3?'),
(96, 4, '=;I,(uIC['),
(97, 3, 'Mn_h:C'),
(98, 3, '4=.w!$DPhtMI '),
(99, 2, '!9a{Q$qW,/8G8,6xgg'),
(100, 3, 'W<M\\{p,"''YXruNv&U');


CREATE ALGORITHM=UNDEFINED SQL SECURITY DEFINER VIEW `v_View_WithHeadline` AS select NULL AS `ID`,`myHeadline`.`myGroup` AS `myGroup`,`myHeadline`.`Headline` AS `myContent`,0 AS `Sleeptime` from `myHeadline` union select `myTable`.`ID` AS `ID`,`myTable`.`myGroup` AS `myGroup`,`myTable`.`myContent` AS `myContent`,sleep(0.1) AS `Sleeptime` from `myTable`;

CREATE ALGORITHM=UNDEFINED SQL SECURITY DEFINER VIEW `v_View_WithoutHeadline` AS select `myTable`.`ID` AS `ID`,`myTable`.`myGroup` AS `myGroup`,`myTable`.`myContent` AS `myContent`,sleep(0.1) AS `SLEEP(0.1)` from `myTable`;


SELECT *
FROM v_View_WithoutHeadline
WHERE myGroup = 1;

+----+---------+---------------------+------------+
| ID | myGroup | myContent           | SLEEP(0.1) |
+----+---------+---------------------+------------+
|  4 |       1 | :aOFtA              |          0 |
|  5 |       1 | PVq@:8.             |          0 |
|  8 |       1 | q                   |          0 |
|  9 |       1 | DWANGTF&            |          0 |
| 10 |       1 | PO&0ABH_gW1K`S a    |          0 |
| 14 |       1 | :FQNA#o^Elg*R1T\    |          0 |
| 19 |       1 | N`A{HD5+_2G7ka~F])  |          0 |
| 21 |       1 | ,"UZHhO V]o"]       |          0 |
| 25 |       1 | U2y|                |          0 |
| 27 |       1 |                     |          0 |
| 31 |       1 | s78KZv n-w          |          0 |
| 32 |       1 | hzd222/%K+WACoJ     |          0 |
| 36 |       1 | c&SF;Q5$oc8?        |          0 |
| 41 |       1 | *'=$+FT             |          0 |
| 43 |       1 | YC'1r)h4zCd=NAE^,rv |          0 |
| 47 |       1 | Q|-!                |          0 |
| 48 |       1 | llB= Kp             |          0 |
| 50 |       1 |                     |          0 |
| 52 |       1 | $XP$Y#M(N-Gg+G,!P#  |          0 |
| 53 |       1 | 8LwT                |          0 |
| 55 |       1 | #|                  |          0 |
| 56 |       1 | B-V%oThy<Sd5kj_w?   |          0 |
| 62 |       1 | 0H'a*JR             |          0 |
| 65 |       1 | v1                  |          0 |
| 74 |       1 | N^YL                |          0 |
| 78 |       1 | &Ee5e1DcX`(=        |          0 |
| 80 |       1 | #ZyZU6 5r*_D$^v) c  |          0 |
| 81 |       1 | My|                 |          0 |
| 82 |       1 | G                   |          0 |
| 83 |       1 | X                   |          0 |
| 85 |       1 | >eL9}%@rNm>RF       |          0 |
| 87 |       1 | Yl                  |          0 |
| 88 |       1 | KauU{rA'            |          0 |
| 95 |       1 | +t9UclCEzdpYiduH#3? |          0 |
+----+---------+---------------------+------------+
34 rows in set (3.42 sec)  <- QUICK!

SELECT *
FROM v_View_WithHeadline
WHERE myGroup = 1;

+------+---------+---------------------+-----------+
| ID   | myGroup | myContent           | Sleeptime |
+------+---------+---------------------+-----------+
| NULL |       1 | Headline 1          |         0 |
|    4 |       1 | :aOFtA              |         0 |
|    5 |       1 | PVq@:8.             |         0 |
|    8 |       1 | q                   |         0 |
|    9 |       1 | DWANGTF&            |         0 |
|   10 |       1 | PO&0ABH_gW1K`S a    |         0 |
|   14 |       1 | :FQNA#o^Elg*R1T\    |         0 |
|   19 |       1 | N`A{HD5+_2G7ka~F])  |         0 |
|   21 |       1 | ,"UZHhO V]o"]       |         0 |
|   25 |       1 | U2y|                |         0 |
|   27 |       1 |                     |         0 |
|   31 |       1 | s78KZv n-w          |         0 |
|   32 |       1 | hzd222/%K+WACoJ     |         0 |
|   36 |       1 | c&SF;Q5$oc8?        |         0 |
|   41 |       1 | *'=$+FT             |         0 |
|   43 |       1 | YC'1r)h4zCd=NAE^,rv |         0 |
|   47 |       1 | Q|-!                |         0 |
|   48 |       1 | llB= Kp             |         0 |
|   50 |       1 |                     |         0 |
|   52 |       1 | $XP$Y#M(N-Gg+G,!P#  |         0 |
|   53 |       1 | 8LwT                |         0 |
|   55 |       1 | #|                  |         0 |
|   56 |       1 | B-V%oThy<Sd5kj_w?   |         0 |
|   62 |       1 | 0H'a*JR             |         0 |
|   65 |       1 | v1                  |         0 |
|   74 |       1 | N^YL                |         0 |
|   78 |       1 | &Ee5e1DcX`(=        |         0 |
|   80 |       1 | #ZyZU6 5r*_D$^v) c  |         0 |
|   81 |       1 | My|                 |         0 |
|   82 |       1 | G                   |         0 |
|   83 |       1 | X                   |         0 |
|   85 |       1 | >eL9}%@rNm>RF       |         0 |
|   87 |       1 | Yl                  |         0 |
|   88 |       1 | KauU{rA'            |         0 |
|   95 |       1 | +t9UclCEzdpYiduH#3? |         0 |
+------+---------+---------------------+-----------+
35 rows in set (10.09 sec) <- SLOW!


select
NULL AS `ID`,
`myHeadline`.`myGroup` AS `myGroup`,
`myHeadline`.`Headline` AS `myContent`,
0 AS `Sleeptime`
from
`myHeadline`
WHERE myGroup = 1

union

select
`myTable`.`ID` AS `ID`,
`myTable`.`myGroup` AS `myGroup`,
`myTable`.`myContent` AS `myContent`,
sleep(0.1) AS `Sleeptime`
from
`myTable`
WHERE myGroup = 1;

+------+---------+---------------------+-----------+
| ID   | myGroup | myContent           | Sleeptime |
+------+---------+---------------------+-----------+
| NULL |       1 | Headline 1          |         0 |
|    4 |       1 | :aOFtA              |         0 |
|    5 |       1 | PVq@:8.             |         0 |
|    8 |       1 | q                   |         0 |
|    9 |       1 | DWANGTF&            |         0 |
|   10 |       1 | PO&0ABH_gW1K`S a    |         0 |
|   14 |       1 | :FQNA#o^Elg*R1T\    |         0 |
|   19 |       1 | N`A{HD5+_2G7ka~F])  |         0 |
|   21 |       1 | ,"UZHhO V]o"]       |         0 |
|   25 |       1 | U2y|                |         0 |
|   27 |       1 |                     |         0 |
|   31 |       1 | s78KZv n-w          |         0 |
|   32 |       1 | hzd222/%K+WACoJ     |         0 |
|   36 |       1 | c&SF;Q5$oc8?        |         0 |
|   41 |       1 | *'=$+FT             |         0 |
|   43 |       1 | YC'1r)h4zCd=NAE^,rv |         0 |
|   47 |       1 | Q|-!                |         0 |
|   48 |       1 | llB= Kp             |         0 |
|   50 |       1 |                     |         0 |
|   52 |       1 | $XP$Y#M(N-Gg+G,!P#  |         0 |
|   53 |       1 | 8LwT                |         0 |
|   55 |       1 | #|                  |         0 |
|   56 |       1 | B-V%oThy<Sd5kj_w?   |         0 |
|   62 |       1 | 0H'a*JR             |         0 |
|   65 |       1 | v1                  |         0 |
|   74 |       1 | N^YL                |         0 |
|   78 |       1 | &Ee5e1DcX`(=        |         0 |
|   80 |       1 | #ZyZU6 5r*_D$^v) c  |         0 |
|   81 |       1 | My|                 |         0 |
|   82 |       1 | G                   |         0 |
|   83 |       1 | X                   |         0 |
|   85 |       1 | >eL9}%@rNm>RF       |         0 |
|   87 |       1 | Yl                  |         0 |
|   88 |       1 | KauU{rA'            |         0 |
|   95 |       1 | +t9UclCEzdpYiduH#3? |         0 |
+------+---------+---------------------+-----------+
35 rows in set (3.44 sec) <- QuICK!


mysql> select version();
+-----------+
| version() |
+-----------+
| 5.5.8-log |
+-----------+
1 row in set (0.00 sec)