How can we create a non-clustered index on the 'email' column of the 'Users' table in SQL? - Study24x7
Social learning Network

Warning: include(./views/auth.php): failed to open stream: Permission denied in /var/www/html/live/loginRightSlider.php on line 18

Warning: include(): Failed opening './views/auth.php' for inclusion (include_path='.:/usr/share/php') in /var/www/html/live/loginRightSlider.php on line 18

Warning: count(): Parameter must be an array or an object that implements Countable in /var/www/html/live/makepost.php on line 52
Database Management System DBMS
4 followers study24x7 01 Jan 1970 05:30 AM study24x7 study24x7

How can we create a non-clustered index on the "email" column of the "Users" table in SQL?

A

CREATE NONCLUSTERED INDEX idx_email ON Users(email)

B

CREATE INDEX idx_email ON Users(email) NONCLUSTERED

C

INDEX CREATE ON Users(email) NONCLUSTERED

D

CREATE INDEX idx_email ON Users USING NONCLUSTERED(email)

Databases
Like Comment Share
study24x7
Write a comment

Warning: count(): Parameter must be an array or an object that implements Countable in /var/www/html/live/makepost.php on line 893

Get the App

Download the Study24x7 App, so you can connect and collaborate.

study24x7
study24x7
Most Related Articles

    Warning: count(): Parameter must be an array or an object that implements Countable in /var/www/html/live/makepostRltdArtcl.php on line 8