How do database indexes work? And, how do indexes help? Provide a tutorial on database indexes. Let’s start out our tutorial and explanation of why you would need a database index by going through a very simple example. Suppose that we have a database table called Employee with three columns – Employee_Name, Employee_Age, and Employee_Address. Assume that the Employee table has thousands of rows. Now, let’s say that we want to run a query to find all the details of any employees who are named ‘Jesus’? So, we decide to run a simple query like this: SELECT * FROM Employee WHERE Employee_Name = 'Jesus' What would happen without an index on the table? Once we run that query, what exactly goes on behind the scenes to find employees who are named Jesus? Well, the database software would literally have to look at every single row in the Employee table to see if the Employee_Name for that row is ‘Jesus’. And, because we want every row with the name ‘Jesus’ inside it, w...
Infowebtutorial blog provide meaning full and useful information about all types of programming languages ,web design ,computer information and window operating system information