RE: [PHP-DB] mssql indexes From: Ryan Jameson (USA) (RJameson <email protected>)
Date: 06/28/02

Hi Gerard,

Every database has it's own way to handle indexes. In my fairly extensive use of MS SQL Server the index is not defined in the table definition. Hence, there probably is no way to dump the indexes directly in, you may have to just create them. It's very easy in SQL, be sure to take advantage of your one clustered index as well, the clustered index improves lookup performance noticeably.

You can build your indexes in Enterprise Manager by right clicking a table, choosing all tasks and managing indexes. You can build indexes on pretty much any field or combination of fields, but if you need a large text field index you'll need to use the option for full-text indexing. I think that's new for SQL Server 2k... but I'm not positive.

That's been my experience.

<>< Ryan

-----Original Message-----
From: Gerard Samuel [mailto:gsam <email protected>]
Sent: Friday, June 28, 2002 3:12 PM
To: php-db
Subject: [PHP-DB] mssql indexes

Hey all. Today was my first time recreating a mysql dump to mssql. Im
using the sql enterprise manager thingy.
I got the table structure and primary keys finished. But Im lost with
mssql options for indexes.
Could someone point me to how to recreate a column index in mssql like
how mysql is??
If I didn't make sense, please dont hesitate to ask for more info...

Thanks 

-- 
Gerard Samuel
http://www.trini0.org:81/
http://dev.trini0.org:81/

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php