RE: [PHP-DB] mssql indexes

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@trini0.org] 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