Re: [PHP-DB] mssql indexes From: Gerard Samuel (gsam <email protected>)
Date: 06/28/02

Thanks for your reply. There seems to be so many options that I felt
like a fish
out of water. Maybe I need to make some mistakes and learn from them.
One last request. I dont see an option to insert default values. Is
this possible in mssql.
Thanks

Ryan Jameson (USA) wrote:

>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