If you want to see how index can be used to improve data search performance, you have to build some large tables, which requires large amount of random data. This tutorial exercise helps you to build a large table with pure random data:
USE GlobalGuideLineDatabase;
GO
– Drop the old table, if needed
DROP TABLE ggl_random;
GO
– Create a table with primary key
CREATE TABLE ggl_random (
id INT,
rand_integer INT,
rand_number numeric(18,9),
rand_datetime DATETIME,
rand_string VARCHAR(80)
);
GO
Related Interview Questions:
- How To Generate Random Numbers with the RAND() Function in MS SQL Server?
- How to recreate the index on a Firebird table?
- How to select a random record from a table?
- How To Generate CREATE TABLE Script on an Existing Table in MS SQL Server?
- How To Generate CREATE TABLE Script on an Existing Table in MS SQL Server?
{ 1 comment… read it below or add one }
At last! Something clear I can udnetsrand. Thanks!