API tools faq
paste
Advertisement
Guest User

perftest.sql

a guest
Sep 11th, 2011
437
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Oracle 11 12.52 KB | None | 0 0
raw download clone embed print report
  1. DROP TABLE my_table PURGE;
  2.  
  3. CREATE TABLE my_table (
  4.     id NUMBER(4),
  5.     GROUP_ID NUMBER(4),
  6.     text CLOB,
  7.     CONSTRAINT mt_id_pk PRIMARY KEY(id));
  8.  
  9. CREATE INDEX my_text_idx ON my_table (text) INDEXTYPE IS CTXSYS.CONTEXT;
  10. CREATE INDEX my_group_idx ON my_table (GROUP_ID);
  11.  
  12. INSERT INTO my_table VALUES(1, 1, 'Lorem ipsum dolor sit amet, consectetur adipiscing elit');
  13. INSERT INTO my_table VALUES(2, 2, 'Sed vel lorem tempus neque hendrerit ultricies non vitae lorem');
  14. INSERT INTO my_table VALUES(3, 2, 'In hac habitasse platea dictumst');
  15. INSERT INTO my_table VALUES(4, 3, 'Nulla accumsan faucibus lobortis');
  16. INSERT INTO my_table VALUES(5, 3, 'Suspendisse et quam a leo molestie feugiat');
  17. INSERT INTO my_table VALUES(6, 3, 'Maecenas porttitor, tortor ut blandit volutpat, sem justo suscipit urna, ut fermentum arcu massa sit amet libero');
  18. INSERT INTO my_table VALUES(7, 3, 'Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas');
  19. INSERT INTO my_table VALUES(8, 4, 'Nulla ac nibh vel lectus pulvinar rutrum ac ut ante');
  20. INSERT INTO my_table VALUES(9, 4, 'Vivamus eget nisi eu sem fermentum malesuada ac vel metus');
  21. INSERT INTO my_table VALUES(10, 4, 'Praesent nec eros lorem, at bibendum ante');
  22. INSERT INTO my_table VALUES(11, 4, 'Nulla luctus dignissim vestibulum');
  23. INSERT INTO my_table VALUES(12, 4, 'Fusce tempor urna sit amet lacus accumsan venenatis in non ipsum');
  24. INSERT INTO my_table VALUES(13, 4, 'Ut sed sem vitae nisi consectetur fermentum');
  25. INSERT INTO my_table VALUES(14, 4, 'Donec a felis mollis urna lobortis luctus at eget urna');
  26. INSERT INTO my_table VALUES(15, 4, 'Proin lacinia molestie risus sed lacinia');
  27. INSERT INTO my_table VALUES(16, 5, 'Mauris et nisi felis');
  28. INSERT INTO my_table VALUES(17, 5, 'Maecenas vel lorem hendrerit ipsum tempus luctus');
  29. INSERT INTO my_table VALUES(18, 5, 'Nunc venenatis nulla a lacus interdum tristique');
  30. INSERT INTO my_table VALUES(19, 5, 'Mauris urna magna, luctus quis porta sed, pellentesque ac elit');
  31. INSERT INTO my_table VALUES(20, 5, 'Sed eu leo eget sapien vehicula cursus id vel enim');
  32. INSERT INTO my_table VALUES(21, 5, 'Integer dignissim tortor at erat dapibus tempus');
  33. INSERT INTO my_table VALUES(22, 5, 'Fusce lorem dui, consectetur vel condimentum a, sodales vitae dui');
  34. INSERT INTO my_table VALUES(23, 5, 'Integer vel odio et turpis ullamcorper feugiat sed quis odio');
  35. INSERT INTO my_table VALUES(24, 5, 'Duis dapibus lectus semper odio egestas mollis');
  36. INSERT INTO my_table VALUES(25, 5, 'Suspendisse et nibh quis ipsum sodales interdum vitae eu mauris');
  37. INSERT INTO my_table VALUES(26, 5, 'Lorem ipsum dolor sit amet, consectetur adipiscing elit');
  38. INSERT INTO my_table VALUES(27, 5, 'Donec odio quam, congue vitae placerat et, rutrum in erat');
  39. INSERT INTO my_table VALUES(28, 5, 'Fusce varius, purus eu rhoncus sodales, felis libero posuere mauris, ut varius turpis tortor sit amet libero');
  40. INSERT INTO my_table VALUES(29, 5, 'Nulla bibendum ullamcorper rutrum');
  41. INSERT INTO my_table VALUES(30, 5, 'Vestibulum at ipsum vitae mauris tincidunt gravida vel vel justo');
  42. INSERT INTO my_table VALUES(31, 5, 'Sed pharetra nunc a tellus pretium feugiat vitae nec ligula');
  43. INSERT INTO my_table VALUES(32, 6, 'Cras condimentum rhoncus facilisis');
  44. INSERT INTO my_table VALUES(33, 6, 'Aenean vel nulla risus, id mollis metus');
  45. INSERT INTO my_table VALUES(34, 6, 'Vestibulum eget molestie leo');
  46. INSERT INTO my_table VALUES(35, 6, 'Nunc vulputate pharetra nulla in imperdiet');
  47. INSERT INTO my_table VALUES(36, 6, 'Donec malesuada rhoncus nulla, et aliquam nunc sagittis a');
  48. INSERT INTO my_table VALUES(37, 6, 'Vestibulum viverra turpis id quam sodales venenatis');
  49. INSERT INTO my_table VALUES(38, 6, 'Nullam porta sollicitudin egestas');
  50. INSERT INTO my_table VALUES(39, 6, 'Vivamus sit amet nisi a neque commodo auctor a ut erat');
  51. INSERT INTO my_table VALUES(40, 6, 'Donec malesuada ultricies luctus');
  52. INSERT INTO my_table VALUES(41, 6, 'Donec tincidunt suscipit arcu, vel venenatis arcu blandit et');
  53. INSERT INTO my_table VALUES(42, 6, 'Sed at odio condimentum mauris vehicula tincidunt vel egestas turpis');
  54. INSERT INTO my_table VALUES(43, 6, 'Nullam a ligula purus, ut rutrum massa');
  55. INSERT INTO my_table VALUES(44, 6, 'Quisque adipiscing, eros vel rhoncus porttitor, elit odio convallis magna, ac porta massa orci et enim');
  56. INSERT INTO my_table VALUES(45, 6, 'Fusce viverra neque sit amet massa bibendum et condimentum odio imperdiet');
  57. INSERT INTO my_table VALUES(46, 6, 'Nunc dignissim commodo enim, a euismod nulla venenatis id');
  58. INSERT INTO my_table VALUES(47, 6, 'Lorem ipsum dolor sit amet, consectetur adipiscing elit');
  59. INSERT INTO my_table VALUES(48, 6, 'Aliquam erat volutpat');
  60. INSERT INTO my_table VALUES(49, 6, 'Nulla facilisi');
  61. INSERT INTO my_table VALUES(50, 6, 'Fusce pulvinar erat vehicula nisl feugiat et suscipit lectus lacinia');
  62. INSERT INTO my_table VALUES(51, 6, 'Donec pulvinar tellus ut felis adipiscing gravida');
  63. INSERT INTO my_table VALUES(52, 6, 'Quisque sed justo massa, a mattis mi');
  64. INSERT INTO my_table VALUES(53, 6, 'Fusce dui lacus, blandit quis malesuada a, aliquam nec quam');
  65. INSERT INTO my_table VALUES(54, 6, 'Mauris volutpat, massa a hendrerit eleifend, diam lacus tempor sapien, sit amet eleifend elit nibh quis dui');
  66. INSERT INTO my_table VALUES(55, 6, 'Duis metus mi, convallis in luctus a, sagittis a urna');
  67. INSERT INTO my_table VALUES(56, 6, 'Sed cursus dictum semper');
  68. INSERT INTO my_table VALUES(57, 6, 'Pellentesque nec odio arcu');
  69. INSERT INTO my_table VALUES(58, 6, 'Praesent augue orci, molestie vel porttitor eget, lacinia in nunc');
  70. INSERT INTO my_table VALUES(59, 6, 'Suspendisse potenti');
  71. INSERT INTO my_table VALUES(60, 6, 'Nullam venenatis urna erat');
  72. INSERT INTO my_table VALUES(61, 6, 'Pellentesque venenatis accumsan diam id tempus');
  73. INSERT INTO my_table VALUES(62, 6, 'Donec ut nisl nibh, vitae facilisis mauris');
  74. INSERT INTO my_table VALUES(63, 6, 'Aliquam erat volutpat');
  75. INSERT INTO my_table VALUES(64, 7, 'Maecenas venenatis nunc et augue dignissim ullamcorper');
  76. INSERT INTO my_table VALUES(65, 7, 'Praesent auctor consequat euismod');
  77. INSERT INTO my_table VALUES(66, 7, 'Donec viverra magna quis quam imperdiet facilisis');
  78. INSERT INTO my_table VALUES(67, 7, 'Mauris malesuada lectus et leo posuere porttitor');
  79. INSERT INTO my_table VALUES(68, 7, 'Donec luctus hendrerit urna, in bibendum eros facilisis id');
  80. INSERT INTO my_table VALUES(69, 7, 'Praesent ac erat nibh, ut facilisis libero');
  81. INSERT INTO my_table VALUES(70, 7, 'Aenean vel elit risus, eu pharetra risus');
  82. INSERT INTO my_table VALUES(71, 7, 'Pellentesque non lorem eu felis adipiscing posuere');
  83. INSERT INTO my_table VALUES(72, 7, 'Donec consectetur, eros vitae pellentesque malesuada, arcu odio tincidunt libero, vel elementum arcu tortor quis lectus');
  84. INSERT INTO my_table VALUES(73, 7, 'Nullam lacinia lectus nec tellus vehicula condimentum');
  85. INSERT INTO my_table VALUES(74, 7, 'Suspendisse porta eros sit amet nibh ullamcorper in egestas ipsum scelerisque');
  86. INSERT INTO my_table VALUES(75, 7, 'Etiam nulla felis, convallis eu facilisis ac, tincidunt vel nibh');
  87. INSERT INTO my_table VALUES(76, 7, 'Proin lectus nibh, eleifend feugiat vehicula et, viverra at purus');
  88. INSERT INTO my_table VALUES(77, 7, 'Aliquam laoreet lacinia pretium');
  89. INSERT INTO my_table VALUES(78, 7, 'Cras luctus est non lectus porta congue');
  90. INSERT INTO my_table VALUES(79, 7, 'Aenean dolor neque, pretium sed congue id, venenatis id elit');
  91. INSERT INTO my_table VALUES(80, 7, 'Integer mattis metus eget lectus dapibus tempus');
  92. INSERT INTO my_table VALUES(81, 7, 'Nulla id enim euismod elit rhoncus lobortis sit amet nec sapien');
  93. INSERT INTO my_table VALUES(82, 7, 'Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Cras sagittis ipsum sed nunc fermentum condimentum');
  94. INSERT INTO my_table VALUES(83, 7, 'Aliquam erat volutpat');
  95. INSERT INTO my_table VALUES(84, 7, 'Cras at enim ut augue rutrum condimentum');
  96. INSERT INTO my_table VALUES(85, 7, 'Mauris id mi at risus vestibulum mollis ut at ipsum');
  97. INSERT INTO my_table VALUES(86, 7, 'Aliquam sodales tortor turpis, et imperdiet tortor');
  98. INSERT INTO my_table VALUES(87, 7, 'Ut ullamcorper fermentum luctus');
  99. INSERT INTO my_table VALUES(88, 7, 'Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus');
  100. INSERT INTO my_table VALUES(89, 7, 'Etiam vehicula pharetra est sit amet molestie');
  101. INSERT INTO my_table VALUES(90, 7, 'In hac habitasse platea dictumst');
  102. INSERT INTO my_table VALUES(91, 7, 'Nulla a nibh sit amet quam vestibulum imperdiet vel adipiscing justo');
  103. INSERT INTO my_table VALUES(92, 7, 'Donec id nulla vel turpis aliquam auctor');
  104. INSERT INTO my_table VALUES(93, 7, 'Ut sit amet dolor mauris');
  105. INSERT INTO my_table VALUES(94, 7, 'Quisque fringilla hendrerit sem, non tempus sapien interdum nec');
  106. INSERT INTO my_table VALUES(95, 7, 'Nullam nec leo quis purus tincidunt commodo ut semper nibh');
  107. INSERT INTO my_table VALUES(96, 7, 'Donec odio orci, sodales in tempor nec, molestie vitae est');
  108. INSERT INTO my_table VALUES(97, 7, 'Donec vel libero non tellus sagittis vestibulum quis a erat');
  109. INSERT INTO my_table VALUES(98, 7, 'Ut varius ultricies faucibus');
  110. INSERT INTO my_table VALUES(99, 7, 'Maecenas ac suscipit lorem');
  111. INSERT INTO my_table VALUES(100, 7, 'Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas');
  112. INSERT INTO my_table VALUES(101, 7, 'Duis sit amet neque quam');
  113. INSERT INTO my_table VALUES(102, 7, 'Donec quis tortor vitae nulla molestie condimentum nec a ante');
  114. INSERT INTO my_table VALUES(103, 7, 'Donec nec ante non dui egestas volutpat');
  115. INSERT INTO my_table VALUES(104, 7, 'Suspendisse potenti');
  116. INSERT INTO my_table VALUES(105, 7, 'Quisque non libero tortor');
  117. INSERT INTO my_table VALUES(106, 7, 'Nulla facilisi');
  118. INSERT INTO my_table VALUES(107, 7, 'Pellentesque rutrum sem eu turpis congue pretium volutpat turpis molestie');
  119. INSERT INTO my_table VALUES(108, 7, 'Aliquam erat volutpat');
  120. INSERT INTO my_table VALUES(109, 7, 'Donec pulvinar pharetra risus ac congue');
  121. INSERT INTO my_table VALUES(110, 7, 'Pellentesque tristique ipsum vel orci condimentum consequat');
  122. INSERT INTO my_table VALUES(111, 7, 'Cras a diam felis, quis posuere ante');
  123. INSERT INTO my_table VALUES(112, 7, 'Quisque malesuada, nisi ut ultrices venenatis, odio lectus dignissim magna, at blandit tellus ipsum at mauris');
  124. INSERT INTO my_table VALUES(113, 7, 'Suspendisse quis quam quis mauris adipiscing ullamcorper');
  125. INSERT INTO my_table VALUES(114, 7, 'Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos');
  126. INSERT INTO my_table VALUES(115, 7, 'Aliquam lectus nibh, aliquet non lobortis quis, dignissim eget elit');
  127. INSERT INTO my_table VALUES(116, 7, 'Nam ac dolor eget metus egestas luctus non ac nisl');
  128. INSERT INTO my_table VALUES(117, 7, 'Etiam id lorem eu tortor convallis tristique');
  129. INSERT INTO my_table VALUES(118, 7, 'Ut libero mi, aliquam sit amet condimentum sed, laoreet vitae lorem');
  130. INSERT INTO my_table VALUES(119, 7, 'Mauris a laoreet augue');
  131. INSERT INTO my_table VALUES(120, 7, 'Aliquam dapibus semper nunc nec varius');
  132. INSERT INTO my_table VALUES(121, 7, 'Morbi rhoncus erat ornare diam malesuada a ultricies nisl pulvinar');
  133. INSERT INTO my_table VALUES(122, 7, 'Aliquam erat volutpat');
  134. INSERT INTO my_table VALUES(123, 7, 'In in diam quam');
  135. INSERT INTO my_table VALUES(124, 7, 'Vestibulum et viverra mauris');
  136. INSERT INTO my_table VALUES(125, 7, 'Proin interdum, sem at dapibus feugiat, nisl magna volutpat tellus, vitae condimentum mi massa eleifend mi');
  137. INSERT INTO my_table VALUES(126, 7, 'Nulla fringilla, mauris id ullamcorper porta, augue nisl dignissim purus, eu accumsan ipsum nulla in enim');
  138. INSERT INTO my_table VALUES(127, 7, 'Etiam in lobortis nisi');
  139. INSERT INTO my_table VALUES(128, 8, 'Suspendisse vitae lectus sed risus mattis dictum sit amet in risus');
  140. INSERT INTO my_table VALUES(129, 8, 'Maecenas aliquam consequat urna eu posuere');
  141. INSERT INTO my_table VALUES(130, 8, 'Vestibulum auctor blandit venenatis');
  142. INSERT INTO my_table VALUES(131, 8, 'Nullam sit amet sapien in mauris molestie pharetra');
  143. INSERT INTO my_table VALUES(132, 8, 'In hac habitasse platea dictumst');
  144. INSERT INTO my_table VALUES(133, 8, 'Morbi semper varius aliquet');
  145. INSERT INTO my_table VALUES(134, 8, 'Etiam eget varius ipsum');
  146. INSERT INTO my_table VALUES(135, 8, 'Donec felis nulla, hendrerit eget convallis at, laoreet vitae orci');
  147. INSERT INTO my_table VALUES(136, 8, 'Proin gravida felis at nunc pharetra rutrum pulvinar nulla posuere.
  148. ');
  149.  
  150. COMMIT;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!