Home
Search results “Oracle select indexes on table”
Collections in Oracle PLSQL
 
13:29
Complete Oracle PL/SQL Tutorial for Beginners Playlist here https://www.youtube.com/playlist?list=PLI5t0u6ye3FE_9SZcS0cQZDU2qn0uB1Oi ************************************************** Composite DataType - Collections in Oracle PL SQL 1. Difference Between Records and Collections 2. Types of Collections in Oracle 3. VARRAYS 4. Nested Table 3. Associative Arrays / Index BY Tables 4. Multi Dimensional Arrays Using Collections and Records
Views: 21803 yrrhelp
A Story of Indexes and Full Table Scans: Finding All the Red Sweets Part 1
 
08:43
"Why isn't Oracle using my index?!" is a common question people have when tuning SQL queries. In this episode Chris compares two methods for finding all the red candies from party bags he's prepared. He shows how these are like a full table scan and an index range scan. He goes on to compare the performance of these two approaches. He shows when a full table scan becomes more efficient than an index range scan and vice versa. ============================ The Magic of SQL with Chris Saxon Copyright © 2015 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
Views: 8837 The Magic of SQL
Database Design 39 - Indexes (Clustered, Nonclustered, Composite Index)
 
13:28
This video covers the basics of indexes. Indexing is an extremely important step of database design. Without Indexes database queries can take a substantial amount of time and hog system resources. The main two classifications of indexes are clustered and non-clustered indexes. Clustered indexes are usually the primary key and determine how the data is actually stored in the table. These are the fastest and most effective. Non-clustered indexes sort a reference to data that is still fast but doesn't actually determine how the data is structured. The best tip I can give you is to use indexes but don't over use them. Having loads of indexes on columns that are barely ever in a where clause or join can bog down the database. This is because every time the table is updated the index must also be updated! When a database looks through a table for certain where conditions on a column that does not have an index, it does an entire table scan. This is not a good practice for large databases (or even small databases but not as bad). With an index the database will do an index seek and quickly find the data you are looking for. Composite indexes consist of two or more columns within one index. Use these when you plan on using the two columns together for a database query WHERE clause. Learn more about indexes here: https://www.calebcurry.com/blogs/database-design/introduction-to-indexes Donate!: http://bit.ly/DonateCTVM2. Courses for Download: http://www.udemy.com/u/calebcurry/ (Use the coupon code "YouTubeDiscount" without the quotes) Facebook: http://www.facebook.com/CalebTheVideoMaker Google+: https://plus.google.com/+CalebTheVideoMaker2 Twitter: http://Twitter.com/calebCurry Subscribe (it's free!): https://www.youtube.com/channel/UCZUyPT9DkJWmS_DzdOi7RIA?sub_confirmation=1 Amazing Web Hosting - http://bit.ly/ccbluehost (The best web hosting for a cheap price!)
Views: 103542 Caleb Curry
Local Vs Global Partitioned Index in Oracle 11g
 
17:30
The Video Explains the difference between Local Partitioned Indexes(Prefixed vs Non Prefixed Indexes). and Global Partitioned Index along with the challenges in maintaining Global partitioned Indexes when the underlying tables partitioned is dropped/truncated/Merged/Moved. Local Partitioned Index Shares the same boundaries as the table and are in the same number as table partitions they are widely used in DSS and DWH systems. While Global Partitioned Index are predominantly used in OLTP systems
Views: 8872 Tech Coach
SQL Index |¦| Indexes in SQL |¦| Database Index
 
09:57
Indexes in SQL are used to speed up SQL queries. A database index works much like an index in a book. For example, if you have a database table with a list of people, a common query would be to lookup someone by name. Creating an index means the database will not have to scan the entire table looking for matches. Instead, it will restrict its search to a small portion of the rows. In this video we use a table with 100 million rows to illustrate how much an index can change the speed of a query. Our SQL playlist starts here: ↪http://bit.ly/Socratica_SQL Be sure to SUBSCRIBE for more SQL! ↪ http://bit.ly/SocraticaSubscribe You may also enjoy our Python playlist: ↪http://bit.ly/PythonSocratica ——————————————— »» To​ ​help​ ​us​ make videos more quickly,​ ​you​ ​can​ ​support​ Socratica at: … ​Patreon​: https://www.patreon.com/socratica … Paypal: https://www.paypal.me/socratica … Bitcoin: 1EttYyGwJmpy9bLY2UcmEqMJuBfaZ1HdG9 Thank​ ​you!! ——————————————— »» You​ ​can​ ​also​ ​follow​ ​Socratica​ ​on: ...​ ​Twitter:​ ​@socratica … ​Instagram:​ ​@SocraticaStudios … ​Facebook:​ ​@SocraticaStudios ——————————————— SQL instructor: Ulka Simone Mohanty (@ulkam on Twitter) Written & Produced by Kimberly Hatch Harrison (@khhsocratica) & Michael Harrison (@mlh496)
Views: 37403 Socratica
Indexes in sql server   Part 35
 
11:14
In this video we will learn about What are indexes Why do we use indexes Advantages of indexes These concepts are applicable to sql server 2000, 2005 and 2008 Text version of the video http://csharp-video-tutorials.blogspot.com/2012/09/indexes-in-sql-server-part-35.html Slides http://csharp-video-tutorials.blogspot.com/2013/08/part-35-indexes.html All SQL Server Text Articles http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html All SQL Server Slides http://csharp-video-tutorials.blogspot.com/p/sql-server.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists
Views: 415571 kudvenkat
DBMS Indexing: The Basic Concept
 
09:52
A quick introduction to the concept of indexing in RDBMSs
Views: 177477 Brian Finnegan
Oracle || Indexes Part-1 by dinesh
 
32:23
DURGASOFT is INDIA's No.1 Software Training Center offers online training on various technologies like JAVA, .NET , ANDROID,HADOOP,TESTING TOOLS ,ADF,INFORMATICA,TABLEAU,IPHONE,OBIEE,ANJULAR JS, SAP... courses from Hyderabad & Bangalore -India with Real Time Experts. Mail us your requirements to [email protected] so that our Supporting Team will arrange Demo Sessions. Ph:Call +91-8885252627,+91-7207212428,+91-7207212427,+91-8096969696. http://durgasoft.com http://durgasoftonlinetraining.com https://www.facebook.com/durgasoftware http://durgajobs.com https://www.facebook.com/durgajobsinfo......
PLS-16: PL/SQL Index By Table
 
29:26
PL/SQL Tutorials For Full Course Experience Please Go To http://mentorsnet.org/course_preview?course_id=5 Full Course Experience Includes 1. Access to course videos and exercises 2. View & manage your progress/pace 3. In-class projects and code reviews 4. Personal guidance from your Mentors
Views: 56406 Oresoft LWC
What is a Materialized View?
 
06:10
http://zerotoprotraining.com This video explains the concept of a materialized view in a database also known as materialized query table an indexed view. Category: Databases Tags: Materialized View
Views: 110408 HandsonERP
B-Tree Indexes
 
04:33
In this video, I'd like to take a look at B-tree indexes and show how knowing them can help design better database tables and queries.
Oracle Tutorial - 10 - indexes
 
10:36
Oracle PL/SQL Query Database. Check more videos on IT courses on iAspireAcademy.org
Views: 22554 iAspireAcademy
Index Organized Tables
 
09:58
Bases de Datos 2 Index Organized Tables Michelle Cersosimo Fernando Mata
Views: 809 Mich Cersosimo
Oracle ||  Index Organized Tables by siva
 
25:46
DURGASOFT is INDIA's No.1 Software Training Center offers online training on various technologies like JAVA, .NET , ANDROID,HADOOP,TESTING TOOLS , ADF, INFORMATICA,TABLEAU,IPHONE,OBIEE,ANJULAR JS, SAP... courses from Hyderabad & Bangalore -India with Real Time Experts. Mail us your requirements to [email protected] so that our Supporting Team will arrange Demo Sessions. Ph:Call +91-8885252627,+91-7207212428,+91-7207212427,+91-8096969696. http://durgasoft.com http://durgasoftonlinetraining.com https://www.facebook.com/durgasoftware http://durgajobs.com https://www.facebook.com/durgajobsinfo............
SQL Server training and interview question:-What is index and how does it make your search faster ?.
 
11:35
For more such videos visit http://www.questpond.com For more such videos subscribe https://www.youtube.com/questpondvideos?sub_confirmation=1 See our other Step by Step video series below :- Learn Data Science in 1 hour :- https://tinyurl.com/y5o7qbau Learn angular tutorial step by step https://tinyurl.com/ycd9j895 Learn C# Step by Step https://goo.gl/FNlqn3 Learn Design Pattern Step by Step https://goo.gl/eJdn0m Learn Azure Step by Step :- https://tinyurl.com/y6fmrech Learn SQL Server Step by Step http://tinyurl.com/ja4zmwu Learn Data structures & algorithm https://tinyurl.com/ybx29c5s Learn MVC Core step by step :- http://tinyurl.com/y9jt3wkv Learn MSBI Step by Step in 32 hours:- https://goo.gl/TTpFZN Learn Xamarin Mobile Programming Step by Step :- https://goo.gl/WDVFuy Learn SharePoint Step by Step in 8 hours:- https://goo.gl/XQKHeP Learn Tableau step by step :- https://tinyurl.com/kh6ojyo Preparing for C# / .NET interviews start here http://www.youtube.com/watch?v=gaDn-sVLj8Q In this SQL Server training video we will understand what are indexes and how they make your search faster. We also run through the fundamentals of B-tree or balanced tree structure. Its also one of those favourite SQL Server interview questions which is asked in SQL Server interviews. We are also distributing a 100 page Ebook "Sql Server Interview Question and Answers". If you want this ebook please share this video in your facebook/twitter/linkedin account and email us on [email protected] with the shared link and we will email you the PDF.
Views: 249586 Questpond
What is Index Scan ,Index Seek and Table Scan?
 
06:34
An index scan or table scan is when SQL Server has to scan the data or index pages to find the appropriate records. index seek happens when data is searched among the index.Please watch full video for detail.
Views: 22122 SqlIsEasy
Heap Tables and Index Organized Tables in Oracle | Chris Saxon
 
02:55
Chris Saxon, a database evangelist, developer advocate, and SQL specialist with Oracle, uses up his two minutes with a tip on using heap tables and index organized tables in Oracle Database.
Views: 2876 ArchBeat Archive
Oracle Tutorial || Online Training || Adv Sql | Index Organized Table Part - 1 by basha
 
33:16
DURGASOFT is INDIA's No.1 Software Training Center offers online training on various technologies like JAVA, .NET , ANDROID,HADOOP,TESTING TOOLS ,ADF,INFORMATICA,TABLEAU,IPHONE,OBIEE,ANJULAR JS, SAP... courses from Hyderabad & Bangalore -India with Real Time Experts. Mail us your requirements to [email protected] so that our Supporting Team will arrange Demo Sessions. Ph:Call +91-8885252627,+91-7207212428,+91-7207212427,+91-8096969696. http://durgasoft.com http://durgasoftonlinetraining.com https://www.facebook.com/durgasoftware http://durgajobs.com https://www.facebook.com/durgajobsinfo......
Why Is My Query Slow? More Reasons Storing Dates as Numbers Is Bad
 
05:25
Storing dates as numbers can cause unexpected problems. In this video Chris looks at one possible issue: inconsistent query performance. He then shows methods you can use to improve performance, including function-based indexes and histograms. ============================ The Magic of SQL with Chris Saxon Copyright © 2015 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
Views: 7693 The Magic of SQL
Clustered vs. Nonclustered Index Structures in SQL Server
 
08:04
Clustered and nonclustered indexes share many of the same internal structures, but they're fundamentally different in nature. Watch Microsoft Certified IT Professional Jon Seigel explain the similarities and differences of clustered and nonclustered indexes, using a real-world example to show how these structures work to improve the performance of SQL queries. Blog post on primary key vs. the clustered index: http://voluntarydba.com/post/2012/10/02/The-Primary-Key-vs-The-Clustered-Index.aspx CREATE INDEX statement reference: http://technet.microsoft.com/en-us/library/ms188783.aspx ALTER INDEX statement reference: http://technet.microsoft.com/en-us/library/ms188388.aspx Index navigation internals by example: http://sqlblog.com/blogs/paul_white/archive/2011/08/09/sql-server-seeks-and-binary-search.aspx Sample index data is from the AdventureWorksLT2008R2 sample database: http://awlt2008dbscript.codeplex.com/releases/view/46169 Visit my channel for more database administration videos: https://www.youtube.com/voluntarydba Subscribe to get notified about my latest videos: https://www.youtube.com/voluntarydba?sub_confirmation=1 Read additional content on my blog: http://voluntarydba.com Follow on Twitter: https://twitter.com/voluntarydba Like on Facebook: https://facebook.com/voluntarydba
Views: 314151 Voluntary DBA
Table Scan Vs Index Scan Vs Index Seek in sql server | by SQL Training Sessions
 
16:52
This session will help you understand following : 1. Table Scan vs Index Scan vs Index Seek 2. How these concepts affects the sql query performance. 3. Explain Actual Execution Plan 4. How to include actual execution plan in sql query 5. How to analyse sql query Thanks for watching! By sql Training Sessions By SQL Enjoy learning :)
Oracle Query Optimization. Partitioned Tables and Indexes
 
02:16:33
In this lesson, an introduction about Oracle Query Optimization. Partitioned Tables and Indexes. How to see plan of query. Monitoring plan of queries. SQL Plan
Views: 67 Mkrtich Pudeyan
Optimizing MYSQL query for speed with indexing large tables left join ASMR
 
03:40
Optimizing MYSQL query for speed with indexing and large tables ASMR so here is my first tip on optimizing speed on mysql queries on large tables with left join joining two tables
mysql tutorial for beginners (6/8) : Indexes
 
05:48
mysql tutorial for beginners (6/8) : Indexes As things stand, the table students works and can be searched without problem by MySQL—until it grows to more than a couple of hundred rows, At that point, database accesses will get slower and slower with every new row added, because MySQL has to search through every row whenever a query is issued. This is like searching through every book in a library whenever you need to look something up. Of course, you don’t have to search libraries that way, because they have either a card index system or, most likely, a database of their own. The way to achieve fast searches is to add an index, either when creating a table or at any time afterward. But the decision is not so simple. For example, there are different index types such as a regular INDEX, PRIMARY KEY, and FULLTEXT. Also, you must decide which columns require an index, a judgment that requires you to predict whether you will be searching any of the data in that column. And even when you’ve decided that, you still have the option of reducing index size by limiting the amount of each column to be indexed. If we imagine the searches that may be made on the students table, it becomes apparent that all of the columns may need to be searched. Anyway, go ahead and add an index to each of the columns, using the commands: ALTER TABLE students ADD INDEX(name(3)); An alternative to using ALTER TABLE to add an index is to use the CREATE INDEX command. They are equivalent, except that CREATE INDEX cannot be used for creating a PRIMARY KEY CREATE INDEX surname ON students (surname(5)); DESCRIBE students; These commands create indexes on both the name and surname columns, limiting name index to only the first 3 characters, and surname index to the first 5 characters. For instance, when MySQL indexes the following name: SAFAA It will actually store in the index only the first 3 characters: SAF This is done to minimize the size of the index, and to optimize database access speed. DESCRIBE command shows the key MUL for each column. This key means that multiple occurrences of a value may occur within that column, which is exactly what we want, as name or surname may appear many times. You don’t have to wait, until after creating a table to add indexes. In fact, doing so can be time-consuming, as adding an index to a large table can take a very long time. Therefore, let’s look at a command that creates the table students with indexes already in place. CREATE TABLE students ( Id_studnet SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT, name VARCHAR(10) NOT NULL, surname VARCHAR(20) NOT NULL, email VARCHAR(30) NOT NULL, INDEX(name(3)), INDEX(surname(5)), ,PRIMARY KEY(id_studnet),UNIQUE(email)); Another important index, PK, its single unique key for each student to enable instant accessing of a row. The importance of having a key with a unique value for each row will come up when we start to combine data from different tables. You can add PK, while you create the table at the first time, or later by issuing the following command: ALTER TABLE students ADD PRIMARY KEY(id_student); The last important index, FULLTEXT index Unlike a regular index, MySQL’s FULLTEXT allows super-fast searches of entire columns of text. It stores every word in every data string in a special index that you can search using “natural language,” in a similar manner to using a search engine. It’s not strictly true that MySQL stores all the words in a FULLTEXT index, because it has a built-in list of more than 500 words that it chooses to ignore because they are so common that they aren’t very helpful for searching anyway. This list, called stopwords, includes the, as, is, of, and so on. The list helps MySQL run much more quickly when performing a FULLTEXT search and keeps database sizes down. FULLTEXT indexes can be created for CHAR, VARCHAR, and TEXT columns only. A FULLTEXT index definition can be given in the CREATE TABLE statement when a table is created, or added later using ALTER TABLE (or CREATE INDEX). Adding a FULLTEXT index to the table students for the columns name and surname ALTER TABLE classics ADD FULLTEXT(name,surname); this index is in addition to the ones already created and does not affect them You can now perform FULLTEXT searches across this pair of columns. If you find that MySQL is running slower than you think it should be when accessing your database, the problem is usually related to your indexes. Either you don’t have an index where you need one, or the indexes are not optimally designed. Tweaking a table’s indexes will often solve such a problem. In the next tutorial, we will learn about, using FOREIGN KEY Constraints and how to join tables together. Subscribe for more: ---------------------------------------------------------------------------- https://www.youtube.com/subscription_center?add_user=saf3al2a SWE.Safaa Al-Hayali - saf3al2a
Views: 31175 Safaa Al-Hayali
26/125 Oracle PLSQL: Index by Tables-Associative Arrays 2
 
13:34
تعلم اوراكل حتى الاحتراف Learn Oracle PLSQL
Views: 1289 khaled alkhudari
Querying Multiple Tables with SQL
 
10:40
Demonstration of how to query two or more tables with SQL Server.
Views: 46418 Larry Domine
Oracle 11g Hints Overview
 
42:56
In this Video tutorial we will discuss about Optimizer hints in Oracle. What is optimizer hint, when & why its needed. Different Category of hints. Description of mostly used hints. Demonstrate how query plan can change with the influence of hint.
Views: 54185 Anindya Das
PART 5.3 Indexing in dbms in hindi basics of indexing in dbms primary secondary clustered
 
20:31
• Counselling Guruji is our latest product & a well-structured program that answers all your queries related to Career/GATE/NET/PSU’s/Private Sector etc. You can register for the program at: https://goo.gl/forms/ZmLB2XwoCIKppDh92 You can check out the brochure at: https://www.google.com/url?q=http://www.knowledgegate.in/guruji/counselling_guruji_brochure.pdf&sa=D&ust=1553069285684000&usg=AFQjCNFaTk4Pnid0XYyZoDTlAtDPUGcxNA • Link for the complete playlist of DBMS is: https://www.youtube.com/playlist?list=PLmXKhU9FNesR1rSES7oLdJaNFgmuj0SYV • Links for the books that we recommend for DBMS are: 1.Database System Concepts (Writer: Avi Silberschatz · Henry F.Korth · S. Sudarshan) (Publisher: McGraw Hill Education) https://amzn.to/2HoR6ta 2.Fundamentals of database systems (Writer:Ramez Elmsari,Shamkant B.Navathe) https://amzn.to/2EYEUh2 3.Database Management Systems (Writer: Raghu Ramkrishnan, JohannesGehrke) https://amzn.to/2EZGYph 4.Introduction to Database Management (Writer: Mark L. Gillenson, Paulraj Ponniah, Alex Kriegel, Boris M. Trukhnov, Allen G. Taylor, and Gavin Powell with Frank Miller.(Publisher: Wiley Pathways) https://amzn.to/2F0e20w • Check out our website http://www.knowledgegate.in/ • Please spare some time and fill this form so that we can know about you and what you think about us: https://goo.gl/forms/b5ffxRyEAsaoUatx2 • Your review/recommendation and some words can help validating our quality of content and work so Please do the following: - 1) Give us a 5-star review with comment on Google https://goo.gl/maps/sLgzMX5oUZ82 2) Follow our Facebook page and give us a 5-star review with comments https://www.facebook.com/pg/knowledgegate.in/reviews 3) Follow us on Instagram https://www.instagram.com/mail.knowledgegate/ 4) Follow us on Quora https://www.quora.com/profile/Sanchit-Jain-307 • Links for Hindi playlists of other Subjects are: TOC: https://www.youtube.com/playlist?list=PLmXKhU9FNesSdCsn6YQqu9DmXRMsYdZ2T OS: https://www.youtube.com/playlist?list=PLmXKhU9FNesSFvj6gASuWmQd23Ul5omtD Digital Electronics: https://www.youtube.com/playlist?list=PLmXKhU9FNesSfX1PVt4VGm-wbIKfemUWK Discrete Mathematics: Relations:https://www.youtube.com/playlist?list=PLmXKhU9FNesTpQNP_OpXN7WaPwGx7NWsq Graph Theory: https://www.youtube.com/playlist?list=PLmXKhU9FNesS7GpOddHDX3ZCl86_cwcIn Group Theory: https://www.youtube.com/playlist?list=PLmXKhU9FNesQrSgLxm6zx3XxH_M_8n3LA Proposition:https://www.youtube.com/playlist?list=PLmXKhU9FNesQxcibunbD82NTQMBKVUO1S Set Theory: https://www.youtube.com/playlist?list=PLmXKhU9FNesTSqP8hWDncxpCj8a4uzmu7 Data Structure: https://www.youtube.com/playlist?list=PLmXKhU9FNesRRy20Hjr2GuQ7Y6wevfsc5 Computer Networks: https://www.youtube.com/playlist?list=PLmXKhU9FNesSjFbXSZGF8JF_4LVwwofCd Algorithm: https://www.youtube.com/playlist?list=PLmXKhU9FNesQJ3rpOAFE6RTm-2u2diwKn • About this video: This video discusses the concept of Indexing in database in Hindi. Important topic of database Indexing like need of indexing in database management indexing, Why we do indexing in files in database, How we do indexing in dbms, Types of indexing, Methods of Indexing, Advantages of Indexing, How to access a file fast in database, Single level Indexing in database file, Multilevel indexing in database file structure in dbms, Dense indexing in database, Sparse Indexing in database, Index file in dbms, Advantages of using Index file in database are discussed. What is Indexing: Additional auxiliary access structure is called indexes, a data technique to efficiently retrieve records from the database files based on some attributes on which the indexing has been done. Dense Index: 1)In dense index, there is an entry in the index file for every search key value in the main file. This makes searching faster but requires more space to store index records itself. 2)Note that it is not for every record, it is for every search key value. Sometime number of records in the main file is greater than = number of search keys in the main file, for example if search key is repeated. Sparse Index: 1)If an index entry is created only for some records of the main file, then it is called sparse index. 2)No. of index entries in the index file is less than No. of records in the main file. Indexing in dbms, Indexing in dbms tutorial in hindi,about indexing in dbms,indexing and hashing in dbms, terminologies in indexing in database,indexing in dbms example,indexing in dbms tutorial,disadvantages of indexing in dbms,indexing in dbms for gate, sparse indexing example, dense indexing in dbms example, DBMS blueprint, DataBase Management system,database,DBMS, RDBMS, Relations, Table, Query, Normalization, Normal forms,Database design,Relational Model,Instance,Schema,Data Definition Language, SQL queries, ER Diagrams, Entity Relationship Model,Constraints,Entity,Attributes,Weak entity, Types of entity,DataBase design, database architecture, Degree of relation,Cardinality ratio,One to many relationship,
Views: 191889 KNOWLEDGE GATE
PLSQL Tutorial: Difference between PL SQL Collections Varray nested table index by table
 
04:07
Difference between PL SQL Collections SQL Tutorial SQL Tutorial for beginners PLSQL Tutorial PLSQL Tutorial for beginners PL/SQL Tutorial PL SQL Tutorial PL SQL Tutorial for beginners PL/SQL Tutorial for beginners Oracle SQL Tutorial
Views: 1582 TechLake
Setting up Full text index on database table
 
07:04
In this video I will show you how to setup up full text index on database tables..
Views: 2099 Adlai King
Part 2   SQL query to get organization hierarchy
 
10:14
Link for all dot net and sql server video tutorial playlists http://www.youtube.com/user/kudvenkat/playlists Link for slides, code samples and text version of the video http://csharp-video-tutorials.blogspot.com/2014/05/part-2-sql-query-to-get-organization.html To get the best out of this video, the following concepts need to be understood first. These are already discussed in SQL Server Tutorial. 1. Self-Join - http://www.youtube.com/watch?v=qnYSN_7qwgg 2. CTE - http://www.youtube.com/watch?v=ZXB5b-7HJHk 3. Recursive CTE - http://www.youtube.com/watch?v=GGoV0wTMCg0 Here is the problem definition: 1. Employees table contains the following columns a) EmployeeId, b) EmployeeName c) ManagerId 2. If an EmployeeId is passed, the query should list down the entire organization hierarchy i.e who is the manager of the EmployeeId passed and who is managers manager and so on till full hierarchy is listed. For example, Scenario 1: If we pass David's EmployeeId to the query, then it should display the organization hierarchy starting from David. Scenario 2: If we pass Lara's EmployeeId to the query, then it should display the organization hierarchy starting from Lara. We will be Employees table for this demo. SQL to create and populate Employees table with test data Create table Employees ( EmployeeID int primary key identity, EmployeeName nvarchar(50), ManagerID int foreign key references Employees(EmployeeID) ) GO Insert into Employees values ('John', NULL) Insert into Employees values ('Mark', NULL) Insert into Employees values ('Steve', NULL) Insert into Employees values ('Tom', NULL) Insert into Employees values ('Lara', NULL) Insert into Employees values ('Simon', NULL) Insert into Employees values ('David', NULL) Insert into Employees values ('Ben', NULL) Insert into Employees values ('Stacy', NULL) Insert into Employees values ('Sam', NULL) GO Update Employees Set ManagerID = 8 Where EmployeeName IN ('Mark', 'Steve', 'Lara') Update Employees Set ManagerID = 2 Where EmployeeName IN ('Stacy', 'Simon') Update Employees Set ManagerID = 3 Where EmployeeName IN ('Tom') Update Employees Set ManagerID = 5 Where EmployeeName IN ('John', 'Sam') Update Employees Set ManagerID = 4 Where EmployeeName IN ('David') GO Here is the SQL that does the job Declare @ID int ; Set @ID = 7; WITH EmployeeCTE AS ( Select EmployeeId, EmployeeName, ManagerID From Employees Where EmployeeId = @ID UNION ALL Select Employees.EmployeeId , Employees.EmployeeName, Employees.ManagerID From Employees JOIN EmployeeCTE ON Employees.EmployeeId = EmployeeCTE.ManagerID ) Select E1.EmployeeName, ISNULL(E2.EmployeeName, 'No Boss') as ManagerName From EmployeeCTE E1 LEFT Join EmployeeCTE E2 ON E1.ManagerID = E2.EmployeeId
Views: 305472 kudvenkat
Stored Procedure Optimization Techniques
 
13:50
Performance Tunning : Procedure : 1.Set Nocount On 2.Set Isolation level Read Uncommited / Nolock 3.Missing Indexes : 4.Scalar function 5.COvering index -- include 6.Partition . 7.Proper Index -- Column Store 9.Try to minimize Physical read 10.Fragmentation issue (Index rebuilding + Reorganizing ) 11.understand Execution planning (opertor )
Views: 17029 SqlIsEasy
How to Join 3 tables in 1 SQL query
 
04:59
Get your first month on the Joes 2 Pros Academy for just $1 with code YOUTUBE1. Visit http://www.joes2pros.com Offer expires July 1, 2015 From the newly released 2 Disc DVD set (SQL Queries Joes 2 Pros Vol2) this video shows how to join 3 tables in 1 query.
Views: 267377 Joes2Pros SQL Trainings
Query to Find Row and Index Count of Database Tables - SQL in Sixty Seconds #029
 
00:51
Above script returns three important details about all the tables of the database. 1) No of NonClustered Index 2) No of the Rows in the Table 3) Table Clustered Index Property (Heap or Clustered Index) A very handy script which I use to get a quick assessment of the database. Find this script here: http://bit.ly/1mNyQuo
Views: 4997 Pinal Dave
SDU Tools   18   List Table and Index Sizes in a SQL Server Database
 
02:11
SDU Tools are a free set of T-SQL tools (Registration is required) to help developers and database administrators (DBAs) working with SQL Server. This video shows how to use procedures from the tools to find the size of tables or the size of both tables and indexes. You'll find more info about SDU Tools and download details at http://www.sqldownunder.com/Resources/SDUTools
Views: 173 SQL Down Under
Locking in Oracle | Oracle SQL Tutorial Videos | Mr.Vijay Kumar
 
21:57
Locking in Oracle | Oracle SQL Tutorial Videos | Mr.Vijay Kumar ** For Online Training Registration: https://goo.gl/r6kJbB ► Call: +91-8179191999 💡 Visit Our Website for Classroom Training: https://nareshit.in/oracle-training/ 💡 For Online Training: https://nareshit.com/oracle-online-training/ #Oracle #Training #CourseVideos -------------------------- 💡 About NareshIT: "Naresh IT is having 14+ years of experience in software training industry and the best Software Training Institute for online training, classroom training, weekend training, corporate training of Hadoop, Salesforce, AWS, DevOps, Spark, Data Science, Python, Tableau, RPA , Java, C#.NET, ASP.NET, Oracle, Testing Tools, Silver light, Linq, SQL Server, Selenium, Android, iPhone, C Language, C++, PHP and Digital Marketing in USA, Hyderabad, Chennai and Vijayawada, Bangalore India which provides online training across all the locations -------------------------- 💡 Our Online Training Features: 🎈 Training with Real-Time Experts 🎈 Industry Specific Scenario’s 🎈 Flexible Timings 🎈 Soft Copy of Material 🎈 Share Videos of each and every session. -------------------------- 💡 Please write back to us at 📧 [email protected]/ 📧 [email protected] or Call us at the USA: ☎+1404-232-9879 or India: ☎ +918179191999 -------------------------- 💡 Check The Below Links ► For Course Reg: https://goo.gl/r6kJbB ► Subscribe to Our Channel: https://goo.gl/q9ozyG ► Circle us on G+: https://plus.google.com/+NareshIT ► Like us on Facebook: https://www.facebook.com/NareshIT ► Follow us on Twitter: https://twitter.com/nareshitek ► Follow us on Linkedin: https://goo.gl/CRBZ5F ► Follow us on Instagram: https://goo.gl/3UXYK3
Views: 24765 Naresh i Technologies
Oracle Tutorial - 8 - indexes_procedure
 
11:04
Oracle PL/SQL Query Database. Check more videos on IT courses on iAspireAcademy.org
Views: 9297 iAspireAcademy
Temporary tables in SQL Server   Part 34
 
15:17
In this video we will learn about 1. What are temporary tables 2. The 2 different types of temporary tables -- Local Temporary Tables and Global Temporary tables 3. Difference between local and global temp tables Text version of the video http://csharp-video-tutorials.blogspot.com/2012/09/temporary-tables-in-sql-server-part-34.html Slides http://csharp-video-tutorials.blogspot.com/2013/08/part-34-temporary-tables.html All SQL Server Text Articles http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html All SQL Server Slides http://csharp-video-tutorials.blogspot.com/p/sql-server.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists
Views: 190699 kudvenkat
Why is my Oracle Database Slow? The SQL Developer Performance Dashboard
 
11:00
Oracle SQL Developer's product manager, Jeff Smith, takes you through the Instance Viewer: a performance dashboard for your Oracle Database. See expensive queries, wait event break downs, and more!
Views: 2238 Jeff Smith
Part 6   Transform rows into columns in sql server
 
08:53
Link for all dot net and sql server video tutorial playlists http://www.youtube.com/user/kudvenkat/playlists Link for slides, code samples and text version of the video http://csharp-video-tutorials.blogspot.com/2014/06/part-6-transform-rows-into-columns-in.html This is another common sql server interview question. We will be using Countries table in this example. SQL to create the table Create Table Countries ( Country nvarchar(50), City nvarchar(50) ) GO Insert into Countries values ('USA','New York') Insert into Countries values ('USA','Houston') Insert into Countries values ('USA','Dallas') Insert into Countries values ('India','Hyderabad') Insert into Countries values ('India','Bangalore') Insert into Countries values ('India','New Delhi') Insert into Countries values ('UK','London') Insert into Countries values ('UK','Birmingham') Insert into Countries values ('UK','Manchester') Here is the interview question. Write a sql query to transpose rows to columns. Using PIVOT operator we can very easily transform rows to columns. Select Country, City1, City2, City3 From ( Select Country, City, 'City'+ cast(row_number() over(partition by Country order by Country) as varchar(10)) ColumnSequence from Countries ) Temp pivot ( max(City) for ColumnSequence in (City1, City2, City3) ) Piv
Views: 208830 kudvenkat
Oracle Database 12c demos: In-Memory Column Store Architecture Overview
 
13:03
The demonstration provides an overview of the architecture of the In-Memory Column Store feature introduced in Oracle Database 12c Release 1 patchset 1.
SQL Performance Table Vs Index Vs View
 
02:43
How the performance of a table Vs Indexed view. Over 300% faster results.
Views: 2505 Tips For IT Pros
Excel Magic Trick 1349: Power Query with Input Variables from Excel Sheet to Extract Records
 
18:02
Download File: http://people.highline.edu/mgirvin/excelisfun.htm See how to use Power Query (Get & Transform) with Input Variables from Excel Sheet to Extract Records and create a Revenue Report. Here are the steps: 1. (00:15) Introduction including Preview of Finished Solution and Preview of steps necessary to accomplish this goal. 2. (02:00) Import and transform Data Set, including removing Columns, Filter For Records and adding an extra Column to calculate Net Revenue using the Number.Round Power Query Function. 3. (06:38) Load Report to Sheet 4. (07:09) Import each Parameter/Criteria Table. 5. (07:36) Convert each Criteria Table to a single Text Item using the Record.Field Power Query Function. 6. (11:38) Declare and Insert Variables into M Code for Report 7. (14:10) Test Reporting System 8. (14:30) Create Recorded Macro To Refresh All and assign it to a Form button 9. (16:40) Test Macro and Reporting System 10. (17:25) Summary
Views: 87812 ExcelIsFun
Indexes Table Filter SQL Command window - English
 
10:34
Indexes, Table Filter, SQL Command window
SQL Server Tutorial 23: Partitioning Tables and Indexes
 
07:05
How to partition a table and an index using SSMS, or T-SQL. For more info, or a copy of the scripts used in this tutorial, please email me at [email protected]
Views: 22617 Johnny Deluca
Query Analysis and Optimizing in Oracle
 
37:53
Database Management Systems 11. Query Analysis and Optimizing in Oracle ADUni
Views: 85376 Chao Xu
Partitioning in Oracle Explained with Real project Examples : Introduction
 
22:43
This Video series will explain partitioning and its use cases referencing real project examples from different domain. It will explain what when and why of partitioning in a simple but elaborate manner. This is the 1st video which explains why partitioning is required and what are the advantages we gain from it. The following videos will explain when should we do it and how.
Views: 32602 Tech Coach
3. MS SQL - Adding Indexes to a Table in Management Studio
 
04:02
Adding Indexes to a Table in Management Studio using Microsoft SQL Server
Views: 1782 Barry Solomon