Skip to main content

SQL CREATE INDEX

SQL CREATE INDEX

One of the most important thing to increase a high performance in a SQL Server database is
creating index to table . index is used to speed up the query process in the sql data
tables, used to find data quickly.(eg)i had an very big query of joining some 5 to 6 sql
tables.when i had little amount of data in those tables i finds the query processing was
good .later on data in those table data where increased day by day.finally i got an [TIME
OUT ERROR].default sql query processing time is 30 seconds.a query have to process with in
that time.we have option to increase processing time.my query took 57 seconds for
executing.then i created index for the necessary column.now i get my query output in 20
seconds.

The CREATE INDEX statement is used to create indexes in Sql database tables.index is used
in the  database to retrive the data faster when search query rised it will serach the
table without reading the whole table.

An index can be created in a table when ever you need the  data more quickly and
efficiently from that table.index cannot be used by the user but it will be helpfull when
search queries are rised.

Eg syntex for creating an index:

CREATE INDEX index_name
ON table_name (column_name)

Created Indexes can easily be deleted with the DROP statement.

SQL DROP INDEX

The DROP INDEX statement remove index from a database table.

Eg syntex for DROP an index:

DROP INDEX table_name.index_name
Labels:

Popular posts from this blog

Dot Net FrameWork

The .NET Framework has two main components: the 1)Common Language Runtime (CLR) and the 2).NET Framework class library. The .NET Framework provides a Runtime environment called the Common Language Runtime or (CLR) that handles the execution of the code and provides useful services for the implementation of the application. CLR: The Runtime can be considered an agent that manages code at execution time. Thus providing core services such as memory management, thread management, and remoting. Also incorporating strict type safety, security and robustness. The Common Language Runtime (CLR) is the virtual machine component of the .NET framework. All .NET programs execute under the supervision of the CLR, guaranteeing certain properties and behaviors in the areas of memory management, security, and exception handling. Class Library: The class library is a comprehensive collection of reusable types that you can use to develop traditional command-line, WinForm (graphical user interface) appli...
Read more

SQL Difference between Union & Union All

SQL Difference between Union & Union All The union and union all operators allow you to combine multiple data sets. The difference between the two is that union sorts the combined set and removes duplicates while union all does not. With union all, the number of rows in the final data set will always equal the sum of the number of rows in the sets being combined.[Learning SQL By Alan Beaulieu] When using the UNION command all selected columns need to be of the same data type. For example : X Y UNION UNION ALL A B A A A B B A B A - B - - - B - - - B - - - A Union all is faster than union, union's duplicate elimination requires a sorting operation, which takes time.
Read more

Accept only numbers in an textbox.

This javascript function is used to make an text-box to accept number alone. JavaScript: function isNumberKey(evt)                                          {                                             var charCode = (evt.which) ? evt.which : event.keyCode                                             if (charCode > 31 && (charCode < 48 || charCode > 57))                        ...
Read more