Online Create Index eLearning
Create Index Training Provider? - Tell us about your Training!
 online course |
 instructor-led class |
 learn at home |
 group study |
 self-directed study |
 cd-based training |
 DVD video training |
 printed book |
 e-book digital book |
 workshop seminar |
 train the trainer |
 computer-based learning |
 discount pricing |
 online tutorial |
From 123-CBT Computer Based Training
Oracle SQL Specifics Creating and Managing Database Objects
...ary.
Match index types to their descriptions.
Use the CREATE INDEX statement to create an index.
Query the USER_IND_COLUMNS view in the data dictionary to display all indexes and the effected column names.
Use the DROP INDEX statement to remove an index from the data dictionary.
Unit 3: Controlling Transactions
Duration: 1 - 2 Hour(s)
Select DML statements from a list of
more...
Oracle SQL Specifics Creating and Managing Database Objects
...ary.
Match index types to their descriptions.
Use the CREATE INDEX statement to create an index.
Query the USER_IND_COLUMNS view in the data dictionary to display all indexes and the effected column names.
Use the DROP INDEX statement to remove an index from the data dictionary.
Unit 3: Controlling Transactions
Duration: 1 - 2 Hour(s)
Select DML statements from a list of
more...
Oracle SQL Tuning Diagnostics and Tuning Schema
Course Overview
This course is the first in a two-part series on SQL Statement Tuning. This course will help experienced application developers to learn a tuning methodology they can use to maximize database performance with minimal effort. Participants will gain experience creating optimal access paths, such as partitioned views, B-tree indexes, bitmapped indexes, index clusters, and hash
more...
Course Overview
This course is the first in a two-part series on SQL Statement Tuning. This course will help experienced application developers to learn a tuning methodology they can use to maximize database performance with minimal effort. Participants will gain experience creating optimal access paths, such as partitioned views, B-tree indexes, bitmapped indexes, index clusters, and hash
more...
SQL Server 7 0 - Implementing a Database - Part 2
...g keys. Select the guidelines which apply when using the CREATE INDEX statement. Perform the steps to create a unique index. Perform the steps to create a composite index. Identify the methods used to view existing indexes. Perform the steps to drop indexes. Perform the steps to allocate a percentage of free space on leaf level index pages. Perform the steps to specify a percentage to
more...
...g keys. Select the guidelines which apply when using the CREATE INDEX statement. Perform the steps to create a unique index. Perform the steps to create a composite index. Identify the methods used to view existing indexes. Perform the steps to drop indexes. Perform the steps to allocate a percentage of free space on leaf level index pages. Perform the steps to specify a percentage to
more...
IBM DB2 Universal Database V6 1--Administration
...alogs. Construct the appropriate type of index using the CREATE INDEX statement. Identify effects of index re-creation strategies. Construct a referential integrity (RI) constraint for a table using the ALTER TABLE statement. Construct a view on a table using the CREATE VIEW statement. Construct a schema using the CREATE SCHEMA statement. Change communications parameters using the UPDATE
more...
...alogs. Construct the appropriate type of index using the CREATE INDEX statement. Identify effects of index re-creation strategies. Construct a referential integrity (RI) constraint for a table using the ALTER TABLE statement. Construct a view on a table using the CREATE VIEW statement. Construct a schema using the CREATE SCHEMA statement. Change communications parameters using the UPDATE
more...
IBM DB2 Universal Database V6 1--Administration
...alogs. Construct the appropriate type of index using the CREATE INDEX statement. Identify effects of index re-creation strategies. Construct a referential integrity (RI) constraint for a table using the ALTER TABLE statement. Construct a view on a table using the CREATE VIEW statement. Construct a schema using the CREATE SCHEMA statement. Change communications parameters using the UPDATE
more...
...alogs. Construct the appropriate type of index using the CREATE INDEX statement. Identify effects of index re-creation strategies. Construct a referential integrity (RI) constraint for a table using the ALTER TABLE statement. Construct a view on a table using the CREATE VIEW statement. Construct a schema using the CREATE SCHEMA statement. Change communications parameters using the UPDATE
more...
