Give example : How I can Use index in sql table
-
Hi, Anyboby can give me real scenario example how to use indexing on the table. Requirement: example in MS-SQL. Thanks
-
Hi, Anyboby can give me real scenario example how to use indexing on the table. Requirement: example in MS-SQL. Thanks
-
Please define your question better. What do you want to do, create an index (try BOL) or decide on what column(s) should be in the index?
Bob Ashfield Consultants Ltd
Hi, GM first of all thanx for replying. mine queries are -how to create index -in which field it should be -explain me this concept in example thanks Ashish
-
Hi, GM first of all thanx for replying. mine queries are -how to create index -in which field it should be -explain me this concept in example thanks Ashish
You are having a laugh aren't you? Can I collect whatever qualification is is you are trying for?
Ashish Kumar Vyas wrote:
how to create index
Try BOOKS ON LINE, thats what they are for
Ashish Kumar Vyas wrote:
in which field it should be
Rather dependant on the table, usage etc etc
Ashish Kumar Vyas wrote:
explain me this concept in example
Where do you start? I know, google! just to show I'm not all bad:
CREATE INDEX index_name ON table(column,column....)Bob Ashfield Consultants Ltd
-
Hi, Anyboby can give me real scenario example how to use indexing on the table. Requirement: example in MS-SQL. Thanks
Create a Database To create a database:
CREATE DATABASE database_nameCreate a Table To create a table in a database:CREATE TABLE table_name ( column_name1 data_type, column_name2 data_type, ....... )Example This example demonstrates how you can create a table named "Person", with four columns. The column names will be "LastName", "FirstName", "Address", and "Age":CREATE TABLE Person ( LastName varchar, FirstName varchar, Address varchar, Age int )This example demonstrates how you can specify a maximum length for some columns:CREATE TABLE Person ( LastName varchar(30), FirstName varchar, Address varchar, Age int(3) )The data type specifies what type of data the column can hold. The table below contains the most common data types in SQL:Data Type Description
integer(size)
int(size)
smallint(size)
tinyint(size) Hold integers only. The maximum number of digits are specified in parenthesis.
decimal(size,d)
numeric(size,d) Hold numbers with fractions. The maximum number of digits are specified in "size". The maximum number of digits to the right of the decimal is specified in "d".
char(size) Holds a fixed length string (can contain letters, numbers, and special characters). The fixed size is specified in parenthesis.
varchar(size) Holds a variable length string (can contain letters, numbers, and special characters). The maximum size is specified in parenthesis.
date(yyyymmdd) Holds a dateCreate Index Indices are created in an existing table to locate rows more quickly and efficiently. It is possible to create an index on one or more columns of a table, and each index is given a name. The users cannot see the indexes, they are just used to speed up queries. Note: Updating a table containing indexes takes more time than updating a table without, this is because the indexes also need an update. So, it is a good idea to create indexes only on columns that are often used for a search. A Unique Index Creates a unique index on a table. A unique index means that two rows cannot have the same index value. CREATE UNIQUE INDEX index_name ON table_name (column_name) The "column_name" specifies the column you want indexed. A Simple Index Creates a simple index on a table. When the UNIQUE keyword is omitted, duplicate values are allowed.
CREATE INDEX index_name ON table_name (column_name)The "column_name